I am using Access 2K on a Windows XP Platform.
I use Split Database with Access on both sides.
I have a back end database (mdb) with about 400 tables that has crashed.
When I open the back end everything seems normal, except that all 400 tables are missing. When I switch to Table View. Forms, Modules, and Queries are all fine.
Only the tables are missing.
Compact and repair, in addition to the MS Access External Compact and Repair Utility do not work. I receive an error that states I don't have permission to modify one of the tables which is a system table.
We make regular backup of the back end, however, when we checked our backups we found that we have to go back six weeks before we have a good backup. Since the front end has been working fine, no one new there was a problem.
Fortunately, all tables are linked to the front end, and I can still view and query the tables from the front end.
I have attempted to recreate the 400 tables in a new Access MDB file, using MakeTable queries, and this works, except the new table General properties are not recreated.
For example, the DefaultValue property, and Description property of each field are blank in the new tables.
I haven't checked, but I would expect to have also lost Format, Mask, Caption, and AllowZeroLegnth a not be as important.
My question is:
Is there a way to recreate tables from the front end of an Access
Database into an external blank database, that allows me to also recreate the table properties, or is there a way I can update the tables in the newly created database to match the table properties in the back end?