0

I'm getting the following error when I try to open a form with Microsoft Access 2002 as a front end to an SQL Server 2000 Database.

"ODBC --connection to 'data source name' failed."

I made a new data source with all the correct information using the Windows ODBC Data source administrator because I know I can connect to the server fine through SQL Server Management Studio and I suppose the problem is with the data source. But I can't figure out how to indicate to Access that I want to use this new data source. I can't find any documentation about this either, so any help would be appreciated, including an explanation of what these data source really are...

studiohack
  • 13,477
Shawn
  • 1,361

1 Answers1

0

Here is the procedure I followed which allowed me to create a new data source and use it (I haven't yet found a way to use the pre-existing data sources, that's why I'm not accepting this answer):

Go to Tools->Database Utilities->Linked Table Manager
Select the "Always prompt for new location" checkbox
Select the concerned table
Click OK
Click "New..." to create a new data source
Select the newly created data source
BINGO
Shawn
  • 1,361