Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 How do I change the SQL server for Access ADP?

Author  Topic 

RC
Starting Member

8 Posts

Posted - 2005-01-13 : 23:20:01
I have MS SQL Server 2000 evaluation version on my desktop PC. I have the SQL Server client tools (only) on the laptop. The two computers are networked. I had an Access MDB database on my laptop, but I converted it with the Access upsizing wizard to an Access ADP database with the Access front-end on the laptop connecting to the SQL Server on the desktop. Now I want to move from this test environment to the "real" server. How do I go about this? Do I make the change from the laptop or the desktop? Do I use the Access drop-down menu, Tools > Database Utilities > Transfer Database? Or maybe from the desktop with: SQL Server Enterprise Manager > Copy Database Wizard?

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2005-01-14 : 06:33:51
RC;
>Or maybe from the desktop with:
>SQL Server Enterprise Manager > Copy Database Wizard?

I think it will be quite good.
Go to Top of Page

RC
Starting Member

8 Posts

Posted - 2005-01-14 : 09:26:52
Thanks, I'll try that. I assume I change the connection string in the ADP file (on the laptop) to point to the new server.
Go to Top of Page
   

- Advertisement -