Remote database locked

[jhham]

Hi,

We have ACT! Premium 2009 Version 11.1.183.0 installed on a citrix server that clients can access but the database files are kept in a seperate file share on another non-windows server.

Recently the following error message has been preventing anyone from opening the database:

"The database you are trying to access has been locked by an administrator. Please try again later."

From what I've read, you can unlock it by using actdiag BUT actdiag only opens local database files. Currently if I open it there is a demo database which is unlocked but it cannot see the networked one.

I tried copying the remote files into the local directory but the database apparently still needs to be imported into actdiag. In the older versions, it appears you could import them. In the current version you have to open it and it imports itself.

So. I'm stuck with a database that I can't open because it is locked and I can't unlock it until it has been opened...

Is there another way to import it into actdiag or otherwise unlock it?

Any help is much appreciated.

[jonmklub · Accepted solution]

Open the pad file in a text editor and verify that it's location is your local machine.  If it's pointing to the server, that is the database that is locked.  If it's not in ACT diag, it's lot on that machine and most likely not a remote database.  If it is a remote database, opening the RDB with file, open and choose .adf instead of .pad will reattach it. 

[jonmklub · Accepted solution]

Open the pad file in a text editor and verify that it's location is your local machine.  If it's pointing to the server, that is the database that is locked.  If it's not in ACT diag, it's lot on that machine and most likely not a remote database.  If it is a remote database, opening the RDB with file, open and choose .adf instead of .pad will reattach it. 

[jhham]

Amazing!

I didn't realize the .pad file was just a pointer to the original database location.

All good now.

Thanks for your help Jon.