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.
| 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. |
 |
|
|
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. |
|
|
|
|
|
|
How do I change the SQL server for Access ADP?