[AccessD] backup database

Hello Marty,

thanks for the help.

Pedro


----- Original Message -----
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, December 13, 2004 11:52 PM
Subject: Re: [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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>