Access Security needed to relink tables and where are the passwords stored?

[MelB]

I have an applicaiton with Access Security. I have a group called Employees that I have limited the access to certain tables to read design and read data. I just added, at the last minute before production, a form with some code behind to relink the tables if they arn't in the location last used. Now the people in Employees can't get through the relink routine, it says they don't have the proper right? What rights are needed so they can do this but not change any data???

I can run the routine if I logon as an administrator to relink the tables but then if the individual logs on they get the relink message? Why?

Also, I initially set up passwords for everyone. I have removed the standard menus so they can't change their passwords. Can someone point me to a routine I can just add to the application to do this? Also, just out of curiosity, where are the passwords kept? In the local front end db, back end, or the mdw?

Thanks in advance!!!

 

[Autoeng]

Passwords are kept in the security file. If the user doesn't have the correct rights (system, not Access) the directory of the back end you can have the problems that you are describing. As far as I know there isn't anything in Access security to keep this from happening so my guess would be to get with your MIS department and play around with settings to the directory.

There are some great ways to add user password forms to your app just do a search and you'll find several. Try www.rogersaccesslibrary.com as well. If you don't find anything get back with me and I'll try to clean up my code well enough to post.

Autoeng

 

[MelB]

They do have the correct network rights... I checked that. I have two seperate mdw files. One is located on the LAN drive to stop unwanted user. I used the instruction on this post...

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=110487#post110487

THe other mdw file is on the locale hard drive with the application and there the user's don't have all rights to all tables. Only the application admin has all rights and they can reconnect... but none of the people defined as application users (group name employees).

Any other ideas...

 

[Autoeng]

Why aren't the tables that the user is trying to connect to in a static location?

Autoeng

 

[MelB]

They are... I'm sorry I wasn't clear. I have a back end data base on the LAN drive. I created an mdw file and put it in the directory so it couldn't just be opened by someone who was just curious.

The front end of the application is loaded on each individual PC with the mdw file that pertains to the forms, reports, ect.

This is my first attempt at Access security so if you have any recommendations that would be great. Right now though, I just need to change which ever security setting is preventing the users from relinking to the back end data... thanks!

 

[Autoeng]

The security that you set on the backend is probably the problem. The users will need certain rights in the back end in order to make the link to the tables. There are some good post here about setting up the back end security just do a search for them.

Autoeng