PC Review


Reply
Thread Tools Rate Thread

BACKING UP ACCESS W/ SQL DB

 
 
=?Utf-8?B?VmFkaW1iYXI=?=
Guest
Posts: n/a
 
      8th Sep 2006
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...
 
Reply With Quote
 
 
 
 
=?Utf-8?B?VmFkaW1iYXI=?=
Guest
Posts: n/a
 
      14th Sep 2006
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..
------------------------------------------------------------------------------------


"Vadimbar" wrote:

> 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...

 
Reply With Quote
 
aaron.kempf@gmail.com
Guest
Posts: n/a
 
      14th Sep 2006
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



Vadimbar wrote:
> 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...


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Backing Up Access Database DDrowe Microsoft Access 5 10th Jan 2008 11:59 PM
BACKING UP ACCESS DATABASE =?Utf-8?B?cGF1bGQ=?= Microsoft Access 4 2nd Nov 2007 04:56 AM
question on backing up access db (97) OM Microsoft Access 3 17th Jul 2007 12:44 AM
Backing Up Access Databases =?Utf-8?B?Q2hhcGxhaW4gRG91Zw==?= Microsoft Access 11 12th Sep 2006 02:58 PM
Re: Backing up an Access Table Danny Sanders Microsoft Windows 2000 Active Directory 0 8th Jul 2004 09:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:01 AM.