Okay. It is possible to get a list of all the local tables in the database:
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;
You could then DoCmd.TransferDatabase to export them.
However, I would expect that process to fail as soon as it reaches one of
the corrupted tables/indexes.
When you reach a table that won't export, you could try deleting all the
relations and indexes.
You may also want to try the undocumented SaveAsText. Once you get the table
out to a text file, use LoadFromText to get it into the new database.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"deko" <ww*******************************@nospam.com> wrote in message
news:%S******************@newssvr14.news.prodigy.c om...
Are you able to make a new (blank) database, and import the existing
tables?
No - I can only export (from the corrupted mdb). If I try to import, I
get
an error. I looked at that link - I think the problem may have been
power-related.