INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...I posted a query a short while ago and had an informed answer within a couple of hours. Terrific!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Project (ADP) Forum

Changing ADP SQL Server Sources

Read More Threads Like This One

rickj65 (Programmer)

1 May 07 10:02

This is probably a simple question, but I haven't figured it out yet...

I've developed an ADP that is linked to a copy of the SQL database on our development server. I now want to deploy a copy of that ADP to a copy of our SQL database on our test SQL server. What is the easiest/best way to do this?

Obviously in the MDB world, I would just relink using the Linked Table Manager. I haven't figured out how to do something similar with an ADP yet.

Thanks,

Rick

ajrimmer (TechnicalUser)

1 May 07 10:11

Never tried this (but will need to soon).

Open the database window in Access. Then go 'file' - 'connection'. That gives you the option to select the server (item 1) & the database name (item 3) (Item 2 being a valid login).

Please let us know if it works (or what else does).

Richard

rickj65 (Programmer)

1 May 07 13:57

That's definitely how it's done. Thanks for the assistance.

Crowley16 (TechnicalUser)

15 May 07 12:05

another tip...

I usually use ado a lot and have connection strings floating about in the code, and what I do is to have a global constant hold a connection string, and all recordsets would look at this global constant, this way, when I need to change servers, there's only 1 point of reference to modify...

--------------------
Procrastinate Now!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Access Project (ADP)