setting up read/write user access

  • Thread starter Thread starter Dan DeCoursey
  • Start date Start date
D

Dan DeCoursey

Does Access 2003 have "internal security" or would I have to just use
NTFS security in order to set users up for read and wirte acces to a Access
2003 database
 
Actually, using NTFS isn't a good approach. Users need the ability to create
files in the folder where the database exists. This is because Access
creates a locking file (ldb) when the first user connects to the database,
updates that locking file when subsequent users connect, and wants to delete
the locking file when the last user disconnects. If a user doesn't have the
ability to work with the locking file, Access will prevent other users from
being able to use the database.

http://support.microsoft.com/support/access/content/secfaq.asp explains how
to implement Access User-Level Security. Read it carefully several times,
work on a copy of your database (just in case!), and make sure you don't
leave out any steps.
 
dude WTF are you talking about?

yes, NTFS can be used to secure an Access db just like it can be used
to secure Excel spreadsheets.
Just don't give people permissions to the NTFS folder and.. uh guess
what happens?

If you want finer-grained control over security; I'd look at SQL
Server.
Seriously. SQL Security Rocks.

-Aaron
 
Back
Top