Security Problem

[1starr]

My users are now unable to access the database. This problem did not begin until a week ago. When ever some of users attemted to open up the database they receive this error: (see attachment) instead of getting the logon box. This occurs even when they are the only one trying to logon. I have check their security setting and could not find anything different than the other users. I need someone who really knows a great deal about MS Access security.

 

[Autoeng]

There is a file created in the same directory as your database with the same name but ending in .ldb. Delete this file and you should be able to get in.

 

[1starr]

Security Problems

I did as you instructed now I am getting this error ( See attachment)

 

[Autoeng]

Well, I hope you have a backup of the workgroup file (*.mdw) cause you're going to need it. I had a similar problem recently where the workgroup file had somehow been corrupted. Replaced with my backup and no problems.

No backup? Check with your IT guys to see if they can pull off a backup restore from the mainframe of the workgroup file.

Don't have that? Man are you screwed. Well, maybe not. You are going to have to get by the security somehow though. Do some searches on "removing security" and you should find some useful information.

Good luck.

 

[1starr]

The problem is that this is only happening to the users who could not gain access because they kept getting the error message that stated the "Admin; file already in use" , now since I corrected that problem they are getting this second error message. No one else is having a problem. I would hate to have to redo security for just 3 users.

 

[Autoeng]

Please describe your db setup. Are you front end - back end? Where is the db located? Where is the workgroup file located? As much specifics as possible will help me to determine what you need to do next.

 

[1starr]

Database is located on the network where everyone can access it. This database was orginally created by someone else. I'm just now taking it over The database was never split nor did the creator but a front end on the desk tops. So all the security setting are located where the database resides. The security setting are set for a user group (which all the users are located) and Admin group where there are only 3 aminstrators, myself and 2 others. I hope this is the information you require.

 

[Autoeng]

The database was never split nor did the creator but a front end on the desk tops.

This is confusing. First you say it was never split but a FE on the destops. That describes a split db. Please clarify.

 

[1starr]

Sorry about that, but what I meant was that there is no font or back end.

 

[Autoeng]

Please post the shortcut target line from the non-working computer. While you're at it verify that they are the same as the working ones.

 

[ghudson]

If the db is shared on a network then you should split it and put a copy of the front end on each users computer [linked to the backend] and you should also put a copy of the workgroup file on each users computer [both files in the same folder]. You should use a custom shortcut to open the db with the workgroup file.

HTH