We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access 95 Security Basics

rbrow
rbrow asked
on
Medium Priority
301 Views
Last Modified: 2006-11-17
Currently, we have a SITES. mdb file and its associated ldb file residing on a file server.  All of the users (50) connect internally to this mdb file over the network.  Each workstation has Access installed on it.  I am at the point where I need security on this mdb file but have the following questions:

Since the Jet engine is on each individual workstation, how do I setup central security?  If I setup a copy of Access on the file server, does that handle the security for all workstations?  What about other users of that file server that have Access applications that have nothing to do with SITES? Will they then be asked to log on to their applications? What happens if security is setup on the SITES.mdb file and a user creates a new database at their workstation?  Would they then have to log in to their new database or would their be no security yet on the new mdb file?  One of my resources is the Access 95 Developer's Handbook by Litwin and Getz, but it doesn't answer these overview type questions.
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks for the answer.  Does the mdw file reside on the server or on each workstation?  If a user tries to access the database on the server from anywhere other than the icon that you have scripted, what happens?

Commented:
the mdw file resides on the server, put in the same folder where workadm.exe is and then reference it in the target .
you put the shortcut on the network where you would put the database and you hide the real database, don't let the users know that this is just a shortcut, let them think it is a real database icon.  therefore, the only way to access the database for them will be through the shortcut, meaning they will have to go through the security.  for instance in my company, i put the database on the server  in one folder, and the shortcut i can put in another folder called database.  then i tell the users: " go to the folder "database" and access the icon called "the company database"".  they go and they have to log on the database because the workadm.exe makes  them log on.
read about workadmin, it tells you everything besides the line i wrote you, myself i spent about 5 hours to find this script.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.