Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to copy table to diff database

Status
Not open for further replies.

fredka

Technical User
Jul 25, 2006
114
US
I am trying to copy a table from one database to another (same table name) I am an error that it cannot use, the file is already in use - I can do this in some databases but not all.

Any idea? thanks!!!

 
Hello:

That would seem to indicate that the database is open somewhere else on your network or computer. Are you importing or dragging the the table to a new database?

Regards
Mark
 
its definately not open anywhere else - I am right clicking and selecting copy - then going to the new database, right clicking and selecting paste - I can do this in other databases ??

Thanks!!
 
Hello:

Try Importing the table to your new database. Select File Get External Data.

Regards
Mark
 
Hello again

If the above works, you may have a corrupt database container.

Regards
Mark
 
Thanks!!! I will try both tomorrow - maybe I should try to compact/repair first. I just created this database today and linked some tables -

Thanks!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top