Home
FrontPage Hosting
mySQL Hosting
Dedicated Servers
Managed Services
Domain Parking

Search our FrontPage Support Area
FrontPage Support Area Site Map

Access to Microsoft SQL Server - Upsizing

You have a local Access Database, and you want to upsize it to a remote SQL Server. 

First of all, your hosting service has to create an empty SQL Server database on their server, and then you have to have a dbo (Database Owner) login ID and Password for that database. 

Once that's done, you use the Access upsizing wizard to create the tables and other database objects on the SQL Server, and copy the data to the server. The upsizing Wizard is fairly easy to use. 

-- Kevin Spencer