Colby, John
JColby at dispec.com
Tue Aug 17 11:17:29 CDT 2004
Are there any memo fields in the table? If so that may be the problem, memos get corrupted. If that is the case it is one or more specific memos (specific records). The easiest way to determine is to create the table structure only (empty) in another db then append all the records to that table. If there are corrupt memos the copy will fail. JWC -----Original Message----- From: Paul Rodgers [mailto:Paul.Rogers at SummitMedia.co.uk] Sent: Tuesday, August 17, 2004 11: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