Pedro Janssen
pedro at plex.nl
Tue Dec 14 10:29:11 CST 2004
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 >