User & Group Permissions problem

[123dstreet]

Hi all,

I have run into a new problem, I have been updating and modifying my database for some time as the Administrator and everything seemed to be running smoothly. When another user tries to open a sales order form, an error message saying, "You can't go to the specified record" pops up. Everything works perfectly when signed in as Admin, but general users (all of them) cannot access this form. Any help would be great!! thanks

 

[apr pillai]

It is not clear how you have implemented Access Rights to Users other than Admins Group.

It is a good idea to create one or more Group Accounts (besides Admins) and assign permissions to the Group Account, add Users to these groups according to their functions with the Database.

It is a better idea to implement Access Security in a sample database and try to learn more about it before you start implementing on production systems.

It is a lengthly subject, please go through the following and others to learn more about Microsoft Access Security:

http://www.msaccesstips.com/2006/11/microsoft-access-security/
http://www.msaccesstips.com/2006/11/create-msaccess-user-account/