March 27th, 2003, 11:59 AM
Connecting to a SQL Server in MS Access
How do I go about connecting to a SQL server in MS Access? I want to use a different database, but still use the forms in Access. I read somewhere that you can connect to a sql server through Access 2002, but what about 2000? Do I need to download anything?
March 30th, 2003, 06:27 PM
Connecting to SQL Server via ACCESS is a 3 step process.
To do this you need a SQL Server driver, the DB user Id and password and probably the service name.
1. Create a DSN that has the SQLserver user ID and password.
To do that go to the Control Panel/Administrative Tools/Data Source (ODBC). Click the System DSN and and follow the prompts.
2. Open a new access database. File/Get External Data/Link Tables. Leave everything blank and select ODBC from the bottom list box. You server should be listed there. If not, Step 1 failed
3. Follow the prompts for logging in and then just pick the tables needed.
It's ugly but it works.
March 30th, 2003, 06:36 PM
Here are some screen shots. Nobody could figure this out without help...hang in there