By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,648 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

How do I change the SQL server for Access ADP?

P: n/a
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?

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<rc*********@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
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?


To move the MSSQL database from the laptop to a server, backup and then
restore is probably the easiest option - this article goes into the details:

http://support.microsoft.com/default...b;en-us;314546

I have no idea what you need to do in the ADP to point it at the new
database - if you're not sure, you might want to ask in an Access/ADP group
about that.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.