Access 2007 ODBC Connection FailedThis is a discussion on Access 2007 ODBC Connection Failed within the ODBC forums in Framework and Interface Programming category; Hello, I built a database in Access 2007. The company recently switched from Access 2000. I build a ODBC connection into a view only SQL database (done many times previously in 2000) and built my database. When completed I went over to a co-workers computer to show the new database. When I opened the database on the co-workers computer I got ODBC --connection to 'servername' failed. So I opened up the database (on the co-workers computer) and updated the linked tables. Once I did that it worked really well. So I went back to my machine and when I opened ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
06-02-2008, 01:16 PM
| |||
| |||
 Access 2007 ODBC Connection Failed Hello, I built a database in Access 2007. The company recently switched from Access 2000. I build a ODBC connection into a view only SQL database (done many times previously in 2000) and built my database. When completed I went over to a co-workers computer to show the new database. When I opened the database on the co-workers computer I got ODBC --connection to 'servername' failed. So I opened up the database (on the co-workers computer) and updated the linked tables. Once I did that it worked really well. So I went back to my machine and when I opened up the database I got the error ODBC --connection to 'servername' failed. Has anyone else seen this issue that it will not connect on multiple computers? Any ideas? -M  |
|
#2
06-06-2008, 08:23 AM
| |||
| |||
| Re: Access 2007 ODBC Connection Failed "mp80237" <mp80237@discussions.microsoft.com> wrote in message news:F0DFC692-4B1B-46E2-8F14-A74214C2D072@microsoft.com... > Hello, I built a database in Access 2007. The company recently switched from > Access 2000. I build a ODBC connection into a view only SQL database (done > many times previously in 2000) and built my database. When completed I went > over to a co-workers computer to show the new database. When I opened the > database on the co-workers computer I got ODBC --connection to 'servername' > failed. So I opened up the database (on the co-workers computer) and updated > the linked tables. Once I did that it worked really well. So I went back to > my machine and when I opened up the database I got the error ODBC > --connection to 'servername' failed. Has anyone else seen this issue that it > will not connect on multiple computers? Any ideas? > -M Best guess is a configuration issue (autostart or ULS). But then one always has to wonder about the provider/driver when ever one 'upgrades'. However, you will be better served to post this question to an MSAccess Developers Newsgroup as it is not a VB issue. -ralph |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 12:58 AM.
