How to connect MS Access form to MS SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bon - 07 Dec 2005 06:34 GMT

Hello all

I created an application which use MS Access 2000 as user interface and
MS SQL Server 2000 as backend. If I want to get data from MS SQL Sever
2000 and display them on the MS Access 2000 form, where do I set the
database connection to the form (i.e. tell the form to get data from MS
SQL server database)?

Thanks

Bon

Reply to this Message

Rog - 07 Dec 2005 09:18 GMT

In Windows control panel, admin tools, data sources (ODBC), create a
system DSN of type SQL server and fill in the parameters for your SQL
database. In Access, select file / get external data, files of type
ODBC. Select machine data source, select the DSN you created and the
table(s) you need.

Reply to this Message