Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 MS Access 97 with SQL Server 2000

Author  Topic 

mparter
Yak Posting Veteran

86 Posts

Posted - 2001-11-20 : 12:58:20
I had an Access 2000 database with tables linked to SQL Server 2000. This worked perfect. But for some reason when I change the database to an Access 97 version and then use it on another machine (with the correct DSN settings) some of the tables don't open and I get a ODBC - Connection Failed error. It's weird cause it only happens on a few of the tables.

Can anyone offer any suggestions?

Thanks
   

- Advertisement -