<rcmail14872@yahoo.com> wrote in message
news:1105677148.106311.272230@c13g2000cwb.googlegr oups.com...[color=blue]
>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?
>[/color]
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
