Link to home
Start Free TrialLog in
Avatar of bfuchs
bfuchsFlag for United States of America

asked on

Copy Access/SQL app to another location

Hi Experts,

When looking at an Access application linked to SQL back end, what is the easiest way to copy all objects into an external drive and setup on a test machine?


Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

I'm not sure what you mean by "all objects". 
  • Is the SQL Server db local or a full database on another server?
  • Is it just an Access database or does it reference external objects?
  • Is there anything else I should know about?

You could split the MS Access app in to client and server sides, then use local storage in Access to hold the tables and other objects needed.
You could also migrate the SQL DB to a local instance of SQL Express and then relink to the Access Application to the local DB backend.
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs


Hi Experts,

I logged in to user today and saw.
1- Whenever entering any code/module screen a pwd is required, guess will have to wait till I obtein the pwd.
2- No DSN is saved under users pc, also saw the wording linked linked linked...on the debug window, which means this is DNS less connection.

Now after I obtain the password/s, what are my next steps?

What version of Access do you have?

Avatar of bfuchs


I have multiple versions Office 365 and also A2003, however didnt check users version...
Sorry for the delay in getting back to this.

With O365 version, just use the linked table manager.   It's been overhauled and much more robust than the old one.

For A2003, you'd probably want to download Dale's Linked Table Manager.

Your other options are:

1. Delete all the tables, and re-link them as they were, choosing the new server as you go.
2. Writing some code to loop through the table defs collection, look for the server name in the .Connect property, and then change it.

   I'm sure I have some code floating around here to do that.

Avatar of bfuchs


Thank you!