Network Security with MDE

[Matthew Ellis]

I have an an access 2000 database with a centrally located backend and a
centrally located MDE file. I would like to have the user level security
settings be connected to the MDE file, but it seems as though it is
individual to each machine with Access. Is there a way around this so that
I dont have to setup up the user level security on each machine? Thanks

 

[Scott McDaniel]

You set up user level security for the application, not for each machine.
Each user would be given a username/password combo that would allow the
workgroup file to recognize individual users. There are many, many issues
you need to consider before attempting to secure this database (the first
being do you still have the original .mdb file which was used to make this
..mde file??).

Before embarking on this journey, download and read-read-read the MS Access
Security FAQs:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfa
q.asp

Also try Jack MacDonald's site:
http://www.geocities.com/jacksonmacd/AccessSecurity.html

 

[Albert D. Kallal]

You have can all users use the SAME workgroup file.

That means you need to provide a shortcut on teach users pc.

The shortcut will run the local copy other of mde (this is good!), but the
short cut will also specify the workgroup file, which should be in the same
place as the backend.

The shortcut will this look like;

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"c:\program files\Rides\Rides.mdb"
/wrkgrp "c:\Program Files\Rides\Rides.mdw"

In above example, I use using a97, but the workgroup shortcut should be to
the server.