CODEWITHSUNDEEP
sql-server-2008ms-access
user2317084
user2317084

Reputation: 321

Access to SQL Server

We currently have an application in Microsoft Access that has some forms connected to tools. We now need to change it so that the application is powered from a Microsoft SQL Server database instead of Microsoft Access.

Is it possible to connect the Access Application to the SQL Server so that the forms continue working the way they do, but update data in the SQL Server database only, and there is no longer any Access database?

Upvotes: 0

Views: 89

Answers (1)

Johnny Bones
Johnny Bones

Reputation: 8402

Yes, you can do this eaily by following these steps:

  1. Set up an ODBC link to your SQL database.

There is an excellent step-by-step tutorial here on setting this up.

  1. Import your Access tables into SQL Server using the Import Wizard

There is an excellent step-by-step tutorial here for using the wizard.

  1. Set up linked tables that point to the SQL Server

Microsoft provides instructions for doing this. Just remember that SQL tables must have Primary Keys assigned, or the data will not be updateable in Access.

Upvotes: 1

Related Questions