Question MSG:"The database has been placed in a state by user..."

[RenaG]

I was in the process of copying a form from one database to another (same database just in different locations). I copied one form over but the next form I tried to copy got this message:

The database has been placed in a state by user 'Admin' on machine 'O43FO1NC186124' that prevents it from being opened or locked.

I tried closing the database but I still get this message.

Other than rebooting my machine, does anybody have any suggestions on how to get out of this 'state'? Any suggestions on how to prevent it in the first place?

TIA,
~RLG

 

[boblarson]

How were you "copying" it over?

 

[RenaG]

Hi Bob,

I was just doing a drag and drop from one db to the other.

BTW - I found a post of yours in this forum that had a link about splitting the db but the link was broken. Do you by any chance remember it or have another one you can share? I wasn't going to split my db but you made a comment that it is not a matter of if but when that an unsplit db will become corrupt. I am on the fence right now about splitting the db and would like more information on the pros and cons.

TIA,
~RLG

 

[boblarson]

He changed web hosts and made website changes. Here's the updated link:
http://www.kallal.ca/Articles/split/index.htm

 

[boblarson]

Hi Bob,

I was just doing a drag and drop from one db to the other.

Not the way to do it. Use either the EXPORT functionality or from the other one use the IMPORT. Copying and pasting or dragging and dropping doesn't have the same exact result.

 

[RenaG]

Hi Bob,

Thanks for the link. I am looking at it now.

Also, thanks for the tip on how to get forms, etc from one db to another. I accidentally discovered the drag and drop method and it worked well for a while and then this locked out thing happened. I can see why the export or import method would be better. Thanks again! I knew I would get the help I needed from this forum.

~RLG