[AccessD] Exporting Access to "Text" for Overcoming Corruption Problems

Hey Brad,

My very first port of call is to import everything from the old database into a new one.  To do this I create the new database and then use the import tool on the ribbon to open up the original database.  Select all the tables, modules, forms etc and import.  It usually takes less an a minutes and fixes the issue 95% of the time.

cheers 
Darryl


________________________________________
From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] on behalf of Brad Marks [BradM at blackforestltd.com]
Sent: Tuesday, 14 August 2012 7:28 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Exporting Access to "Text" for Overcoming Corruption Problems

All,

I have seen several posts over time regarding a way to deal with a
corrupted Access database by exporting the various components to "text"
and then importing them back into Access.

I would like to learn more about this process.

Is there a way to export all components and then import all components
into a new accdb file?

Does anyone have an example of how to do this?

Thanks,
Brad

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