[AccessD] backup database

This will work in Access 97 and up and saveand restore  all 
tables,daps's,referential integrity,db diagrams, and menu bars.

SavesAsText 6,"", "C:\mydata\mymdbtablesave.txt"

then to reload in a fresh mdb

LoadFromText 6,"", "C:\mydata\mymdbtablesave.txt"

This can be a big text file probably 1/3 larger than all your tables 
combined..
The magic number 6 is the constant acDataAccessPage which doesn't exist 
in Access97

Gustav Brock wrote:

>Hi Pedro
>
>Yes there is. 
>Look up in the archive "SaveAsText, LoadFromText" from 2004-07-25 and
>-27.
>
>/gustav
>
>  
>
>>>>pedro at plex.nl 12-12-2004 20:56:15 >>>
>>>>        
>>>>
>Hello Group,
>
>is there a way to backup the backend as a tekstfile in columns or as
>excel file, with one click of a button.
>
>I don't want to open each table and save them by hand to a different
>folder as the default folder where the database is in.
>
>Pedro Janssen
>--
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada