Network Security

[matt nassar]

I have recently been informed that all of the databases that exist on the network where i work need to be secured, so that access is only given at the user level. After playing around with the security features, however, i realized that i had not secured the database that i was trying to secure over the network. The only place that the security presented itself was on my own computer. In addition, all databases on my computer now require passwords upon opening them. So my real question here is how do i set up security so that it can secure a network database to multiple users, from multiple computers. If anybody could help me with this lil problem it would be greatly appreciated!

Hopelessly confused...

Matt

 

[ghudson]

Check this site out for a great article on Access security.

http://www.jmhare.com/dbsecurity.htm

I am just guessing but I think that you altered your computers System.mdw file @ C:\Windows\System\

You need to create a custom security file (rename it).

You need to grab a clean System.mdw file from another PC that has the same version as yours and replace your file. Rename your old System.mdw file or move it just in case you need to use it again.

Once you have the System.mdw file restored, you need to rejoin your computer to the restored System.mdw file to prevent having to log into any Access file.

You should never join a users PC to your custom workgroup files. Use shortcuts with the correct user security info so that they can open your secured db's.

Also, check this thread out...
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30833

HTH

 

[matt nassar]

Thanks!!!

Thanks for the tips!! Ive got a test database up and running with great security results! Thanks again for your help MAtt

 

[The_Doc_Man]

Here's a thought you might need to bounce past your network folks.

In order to use Access correctly on a shared drive, those users who are supposed to have the ability to use Access need the following rights (perhaps only in that directory.)

Create new files (because if you are the first person to log in to the database, YOU get to create the lock (.LDB) file.)

Delete existing files (because if you are the last person to log out of the database, YOU get to deleted the lock (.LDB) file.)

Read & Update (because if you are NOT the only person in the DB then you have to share the .LDB file and .MDB file.)

In NOVELL sharing, the rights are Read, Write, Erase, Create, Modify, File Scan

Don't know off the top of my head what they would be in other protection schemes.

Fortunately, if you create a fairly high-level directory for the files, you can restrict only that directory to the required rights and still have totally different security on other parts of the directory tree.