Sometimes, when I drag an object (form, report, module, query) from a database to another FE, I receive the following error message:
The Database has been placed in a state by user 'Admin' on machine 'myComputerName' that prevents it from being opened or locked.
The error has OK and Help buttons.
OK closes the error and import fails.
Help sends me to this page and I have no idea what it's saying.
If I close the target database and open it again, this time everything is OK. No error and the object will be imported.
FE is on local drive.
BE is our university's sql server.
No one has access to this FE except me.
Only one instance of the FE is opened. (When I close the FE, lock file disappears)
My questions:
1- What does this a state exactly is?
2- How and why does it happen?
3- Is there any way to bypass this error without closing/opening FE?
thanks.[/b]
The Database has been placed in a state by user 'Admin' on machine 'myComputerName' that prevents it from being opened or locked.
The error has OK and Help buttons.
OK closes the error and import fails.
Help sends me to this page and I have no idea what it's saying.
If I close the target database and open it again, this time everything is OK. No error and the object will be imported.
FE is on local drive.
BE is our university's sql server.
No one has access to this FE except me.
Only one instance of the FE is opened. (When I close the FE, lock file disappears)
My questions:
1- What does this a state exactly is?
2- How and why does it happen?
3- Is there any way to bypass this error without closing/opening FE?
thanks.[/b]