Charlotte Foust
charlotte.foust at gmail.com
Wed Aug 15 23:16:12 CDT 2012
It also doesn't explain things like needing references set in that new blank database. I'd never used the method but got curious and played with it. One interesting thing I ran into is internal files Access creates that are part of the built in bloat in 2002 and later. There are scads of query files named ~sq_somthing and lots of tables with ~Tmp at the start of the name. I added some tests to exclude those. If access really needs them it can recreate them for itself! Charlotte On Tue, Aug 14, 2012 at 6:47 AM, Jim Hewson <jm.hwsn at gmail.com> wrote: > Brad, > There is a way to export all objects (including tables) to text and then > import them back into the database. > I've done it. In my case, my problem was importing the text files back > into the database. The basic process is to export into text files, delete > ALL the objects, compact and repair, then import the text files back into > the database. I'd recommend the export the objects then create a new blank > file and import into the new file. > > Try this link for code to do it. It doesn't explain the import very well > but you can get it to work. > http://www.access-programmers.co.uk/forums/showthread.php?t=99179 > > > > I also have a mdb file that takes does it for you that I received from Dan > Waters that I had to tweak a little but it really works well. > > Good luck. > > Jim > > On Mon, Aug 13, 2012 at 4:28 PM, Brad Marks <BradM at blackforestltd.com > >wrote: > > > 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 > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > >