Office XP / Access 97 / Sql Server 2000

S

Steve W

We have a global Word template that calls a VB6 COM dll. It uses an Access
97 database with some tables that are linked to SQL Server 2000.

Our client has upgraded some users to Office XP (some users on Win XP, some
on Win 2000). These users then intermittently get an ODBC error ('failed to
connect to SQL_DB' - where SQL_DB is the name of the Sql database).

For all users, this data access works the first time (the first time they
try it after opening Word). Then it varies - some users get the error the
second time they try, other users can do it 10 times before getting the
error.

Anyone got any ideas ?

TIA

Steve
 
P

PRL

Might be due to different versions of Jet db engine. Try applying latest Jet sp (8 I think) to all machines.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't save my Office documents (after computer rebuild and reauthorization) 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
error message OLE server or active x control 0
Keeping Access Running Between SQL Server Reboots 3
Recover a corrupt MDF in SQL 2K 0
Slow ODBC Queries to SQL 2000 4
Best way to deploy Access read-only database that is linked to SQL tables 6
Test Connection to SQL Server 7

Top