Access Locking File

[HaworthBantam]

I have 3 backend databases on a server, a live database, archive database and a database that holds some security information.

On each of the 95 users workstations is a local database that links to each of the 3 backends.

This morning none of the users could access the local application.

I checked the backend databases in turn and found that the problem appaers to lie with the live database, an error message appears when I try to open it - "Couldn't use [Pathway and file name here]; file already in use". There is no locking file and the mdb file has the same permissions as the top level folder in which it resides.

Does anyone have any ideas as to what my problem may be ?

Thanks.

 

[Craig0201]

Your DB has corrupted. Kick everyone out then use repair.

Craig

 

[HaworthBantam]

Already tried that but when I try to open the database or open access and link to the db to repair the error occurs.

 

[Hap007]

Dear HaworthBantam,

Someone has the backend database open and locked, even though everyone appears to be out of the application.

This might happen if on one user's PC, your application did not exit from memory even though the user appeared to exit.

If you have network software that can tell you which work station has locked the file, then reboot that PC, otherwise.

You will need to free up the file using brut force.

1) You could have all users power down.
or
2) If the file is still locked, then restart the server, that will free the file and then you can compact and repair if necessary.

Good Luck,
Hap

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[HaworthBantam]

Thanks Hap,

I'd guessed what you'd said was the case.

I was plucking up the courage to reboot the server but that would affect a lot more people than the 95 users having the problem.

Your lateral thinking solution of having the workstations reboot is marvy. I shall give it a go.

Thanks mate.

 

[Hap007]

Dear HaworthBantam,

7 more thoughts.

1) I have had similar problems but with 60 users, so your problem is worse.
I would walk the halls and have everyone exit, but som impatient users would give me 5 minutes and fire it back up, so make sure all stay out.

2) Make sure no manager, who might be out, his office door locked, is not the culpret.

3) Make sure no off center app has the file open. maybe a new application that just 'views' the data.

4) Make sure no SQL Server has attached to the DB, that will keep it open.

5) Make sure that the 'Server' itself is not running Access and has the file open.

6) No one has added a new app(recently) that may also open the file.

7) Internet access of the file?

Good Luck,
Hap

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers