[AccessD] A table that can't be duplicated

Joe Hecht jmhla at earthlink.net
Tue Aug 17 10:51:57 CDT 2004


Look and see if the a security file failed to close. Sometimes they stay
open and make the database think a table is in use.

Joe Hecht
jmhla at earthlink.net
28g
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Rodgers
Sent: Tuesday, August 17, 2004 8:47 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A table that can't be duplicated

The main table in a database won't be copied. Access says another user is
busy with the table. But this is not so.

I can't copy the table and rename the table, I can't import it into another
database, I can't use a MakeTable query to do it that way. 

I can copy the whole database, but that same table in the copied database
refuses to be copied - or to be renamed.

I can steal it with Excel - but then I lose all the lookups and the like.

Anyone had this problem before please, anyone found an answer, please? 
Cheers paul

 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list