BACKING UP ACCESS W/ SQL DB

[Vadimbar]

Is it possible to backup Access wioth all the trimmings?
I have multipple tables with forms and several SQL links. How can I back up
the SQL along with the rest of ths Db and still maintain the links?
Thank you,
Vadimbar...

 

[Vadimbar]

Let me try once more. I have reviewed other posts and have not found anything
that matches my situation. I have Access 2002 with multiple SQL ODBC links. I
would like to back up all the Data and copy the links to convert them to
imports. Is there a way to do this with out importing each and every SQL ODBC
link. There are so many links that I will be doing this until next new year.
Please help if you can.
Thank you,
Vadimbar..

 

[aaron.kempf]

u can either learn to write a simple loop; or you should move
everything to sql server and then use a real backup program to keep
track of your data

MDB is for babies.

SQL Server won the war. Access Data Projects allow you to keep many of
your existing forms and reports... of course you might need to rewrite
some queries.

Sprocs and views are a thousand times more powerful than stupid access
queries

-Aaron
ADP Nationalist