Question Database has been placed in a state of admin by

[Rik_StHelens]

Hi

I have a database which has a front end on 6 local machines, and the data tables sat on the server.

I have just started getting the error message "database has been placed in a state of admin by...." as i am editing some reports which need to be updated, which live in the local front end on my machine. I was then going to transfer them onto everyone elses local front ends.

it says the DB has been placed in a state of admin by machine other than my own. i have checked for a lock on that machine, and on the tables on the server, but have found nothing. I have also rebooted my machine, and the machine in question to no avail.

Any ideas what this could be?

Thanks!

 

[Trevor G]

Is the ldb file still open on the server?

Trevor

 

[Rik_StHelens]

Is the ldb file still open on the server?

Trevor

nope. I checked that one as well.

 

[Rik_StHelens]

having done a bit more digging i only get the problem when i try to run/edit 1 report.

every thing else works fine

 

[ghudson]

You should be opening the db in the exclusive mode to ensure nobody else is in the db when making design changes to a live db.

 

[Rik_StHelens]

You should be opening the db in the exclusive mode to ensure nobody else is in the db when making design changes to a live db.

I only make changes to my front end. Every one here has their own local front end on their machine, and the data tables sit on the server.

If i'm making tables changes then obviously i make sure people have got out of the DB. But I never do when changing the front end because its local.


I have solved the problem however. We have 6 identical dell pcs, and 3 of them have been SWAPPED. So, when i rebooted the PC i thought was causing the problem, it had been moved to another desk.

No one tells me anything here .....