Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Access 2007 ODBC Connection Failed
30 views
Skip to first unread message
mp80237
Jun 2, 2008, 1:16:02 PM6/2/08
to
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
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
Ralph
Jun 6, 2008, 8:23:30 AM6/6/08
to
"mp80237" <mp8...@discussions.microsoft.com> wrote in message
news:F0DFC692-4B1B-46E2...@microsoft.com...
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
0 new messages