Before upsizing your Access database to SQL server you must have an existing SQL account.

1. Open your existing database inside of Access and choose Tools > Database Utilities > Upsizing Wizard.

2. Once the wizard has started choose "Use existing database" and click "Next." You will then be asked to choose a data source. If you already have one set-up for your SQL account, you may select it here and skip to step eight.

3. Go to the "Machine Data Source" tab and click New

4. Choose a user or system data source depending on your security needs. Then select "SQL Server" from the list and click "Next" and "Finish."

5. You will then be prompted for the SQL server information. You received this when you signed up for your SQL account. The name can be anything you wish to refer to the data source with. The description field is optional and the server is the IP address of your SQL server.

6. On the next screen choose to login using "SQL Server Authentication." Enter your username and password for your SQL account and click "Next."

   Note: Be sure "TCP/IP" is selected in the "Client Configuration."

7. Leave the next two screens at their default settings and click "Finish." This will pop-up a confirmation screen where you can test the data source.

8. Once you have your data source created, make sure it is selected from the list and hit "OK."

9. Enter your SQL password and hit "OK."

10. You will then be asked which tables you want to convert to the new database. Move the tables you wish to convert into the window on the right and click "OK."

11. Leave the remaining settings at their defaults unless you know you need to change them. Click "Finish."

Congratulations! Your database is now residing on the SQL server.

If you are using ASP to connect with your database your code should remain pretty much the same. One thing that will need to change is the connection string or data source name.

If you are using a DSN to connect with your access database you will need to change it to the DSN you chose when requesting SQL setup.

If you are using a connection string with your access database it may have looked like this:

Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\InetPub\YourDomain.Com\Database.mdb

Your new SQL connection string will look like this: