Make a copy of a linked SQL db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to make a desktop copy of a query driven db that is linked to
a SQL (tables) backend? I want to make a copy for testing data without
messing up the live db.
 
Troy

Have you tried creating a new Access .mdb file and importing (a copy of) the
tables?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Do you mean Microsoft SQL Server Back-End?

If so, you can purchase a Microsoft SQL Server (Developer's edition) and
install it on your desktop then you can use the back-up from the production
system to create a test copy of the Back-End on your Desktop.

Alternatively, you can simply use the back-up to create a test database on
the production server.
 
Do I need to have everyone off the database before I transfer all the tables
to my desktop? I just need to make a copy of the existing database so I can
do modifications to it without working on the live database. I have tried to
start with a blank database and use the structure only section but it keeps
reattaching the original tables. Is their any other way besides buying an SQL
copy for my DT? If so what is the procedures I need to follow? Thanks again
 
Are your Back-End Tables in the Microsoft SQL Server or just an Access
Back-End?

While you can create a test copy of the Back-End in Access / JET (as per
Jeff's advice), it is much better to use a Microsoft SQL Server Back-End for
development / testing if your production Back-End is an SQL Server database.
Testing on an Access / JET Back-End does not mean that your development will
work on a SQL Server Back-End!
 
Back
Top