Problems creating ‘New Copy’. I am trying to make a ‘New Copy’ of a database. But, I keep receiving the message ‘Database is currently in use by you or another user’. How can I correct this problem to make a new copy database?
Subject: Problems creating ‘New Copy’ database
If you are accessing the db on a server, then
-
make sure no one is accessing the db locally or via the filesystem on that server.
-
a show users will show who is using the db.
-
try a drop all command at the server console, to drop the users
Subject: RE: Problems creating ‘New Copy’ database
Make sure you don’t have a form or view open in designer locking the db out…
Done it many a time and then kicked my own azz…
Subject: RE: Problems creating ‘New Copy’ database
Thank you, Torstan