Access Db remote access

[Guest]

Hello All-
Sorry for my stupid questions

I am considering a project that would be my first Access Db.

My questions:

1- I believe it is possible to control which users can access certain
fields, correct? Example: The Db would include the price we pay for products,
the price we sell them for, and the profit margin. Only certain individuals
should have access to the cost and the profit margins..

2- The Db would need to be accessed remotely by some individuals, but we
don't want to have the Db on the internet.. What are some options?
Example: Product updates on the web are handled outside the company. We
would like the web guys to be able to query the Db for updates they should
apply to the web. We would also like them to mark the record when the upates
have been completed. We do not have VPN capability. We currently hold all
data in a excel sheet that is "passed around" on email..

Any guidance would be much appreciated..

Thanks in advance..

David H.

 

[AnandaSim]

1- I believe it is possible to control which users can access certain
fields, correct? Example: The Db would include the price we pay for products,
the price we sell them for, and the profit margin. Only certain individuals
should have access to the cost and the profit margins..

There are several flavours of security.

1. You need to identify the user either by forcing the user to log in
before the screen shows data (workgroup security), or you deploy
specific front end mdbs with particular forms to certain users
(cooperative security).

2. In the login mechanism, you can invent your own or you can use
Workgroup Security mechanism.

Workgroup Security:

http://support.microsoft.com/kb/165009

2- The Db would need to be accessed remotely by some individuals, but we
don't want to have the Db on the internet.. What are some options?
Example: Product updates on the web are handled outside the company. We
would like the web guys to be able to query the Db for updates they should
apply to the web. We would also like them to mark the record when the upates
have been completed. We do not have VPN capability. We currently hold all
data in a excel sheet that is "passed around" on email..

You don't want to put the db on the internet?
Internet means connection via TCP/IP via the internetwork of machines.
Hence, if you say you don't want to connect via "the internet" you are
saying that you will need the user to directly dial your premises.

If you dial your premises you need a bank of modems at your premises.
And the phone bandwidth will not be sufficient to run Access. You will
need to have a machine running Citrix or Microsoft Terminal Services
over your modem infrastructure.

HTH
Ananda

 

[Pieter Wijnen]

DSL will provide enough bandwith
I'm currently hooked up to Russia via a 700K link (including satelite)
for a single remote user, the remote desktop functionality of WinXP is
sufficient
A Terminal Server for up to 5 users isn't that pricy either & could as a
bonus enable you to work from home ;-)

These solutions should include a VPN solution (Firewalls with VPN aren't to
expensive either)

Another solution would be to create a replicated Database.

Or make the database available to the Web Server (will be some secuity
issues)
& make some web pages to update the Db

HtH

Pieter