"Could not use 'Admin'; file already in use" - Error Message

[LeanneGodney]

Anyone have any clues about what this is talking about?

I have an access database with an access backend using a security file situated on the server. Each user gets their own frontend and they all link to the backend file and the security file.

Everyone else is working fine, but one PC is giving me this error. They can run the installation file I've created, which copies the frontend file to their pc and places the shortcut (containing the statup file and security file). When they double click the shortcut they get the stated error.

Any help would be most appreciated, as I've never had this error before!

Thanks,
Leanne

 

[lupins46]

My guess would be a problem with permissions on the backend folder for that user.

 

[soulcracker]

I am having the same problem as Leanne. However, I can't even a blank database on either one of the two PC's that are having this problem. The users have change access to the security file and the databases on the file server. Has anyone ever encountered this problem and fixed it. Any help would be greatly apperciated.

 

[LeanneGodney]

Hi Soulcracker,

It appears that Lupins46 was correct about my problem. The user didn't have the relevant permissions for the backend file on the server.

However, your problem sounds like something that was going wrong on another one of the users pc's.

For some reason Access chose to modify the standard security file and make the user log into my one security file whether it needed to be secure or not. I also couldn't create any databases on that machine cos it kept wanting me to login to teh security file.

All I did was go into Tools --> Security --> Workgroup administrator, grabbed the path to the workgroup file and then located the file through windows explorer and deleted it. That forced Access to recreate the standard security file which in turn stopped them from having to log in to every database they tried to open or create.

Does this make sense? Is this what's happening?

Leanne