Avatar of bfuchs
bfuchs
Flag 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?

Thanks

Microsoft AccessMicrosoft SQL Server

Avatar of undefined
Last Comment
bfuchs

8/22/2022 - Mon
Kelvin Sparks

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?

Kelvin
James Jeansonne

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.
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
bfuchs

ASKER
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?

Thanks
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jim Dettman (EE MVE)

What version of Access do you have?

Jim.
bfuchs

ASKER
I have multiple versions Office 365 and also A2003, however didnt check users version...
Jim Dettman (EE MVE)

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.

Jim.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
bfuchs

ASKER
Thank you!