By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,523 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

problem accessing access 97 database through odbc on windows 2003 sp1

P: n/a
Hello,
We have a legacy application which relies on an Access 97 database
(upgrading is nog an option atm). As we are setting up a new server
(Windows 2003), we started experiencing problems running that
application after installing all required updates (Windows, Office, ..)
It did work before updating, with a basic OS + application
installation. Somewhere an update dit break things, but we do not know
which one.

Now for the problem. When starting the application, following error is
returned:

---------------------------
ODBC Microsoft Access Driver Login Failed
---------------------------
Cannot open a database created with a previous version of your
application.
---------------------------
OK Cancel
---------------------------

OK let's you choose another mdb (not an option) and CANCEL fails the
app, which is the problem :-)

Current versions:
* JET version: 4.0.6305.00 - not sure which this is, it's more recent
than JET 4 SP8 which is the lates I can download separately.
* Office 2000 SR1 with latest updates
* MDAC 2.8 SP2 ON WINDOWS SERVER 2003 SP1 (2.82)(ComponentChecker 2.0)

What we tried so far, to no good:
* http://support.microsoft.com/default...;EN-US;Q310804
* http://support.microsoft.com/default...b;EN-US;310937
* downgrading MDAC, which is seems useless (has no effects on file
versions + no relation to odbc?)
* downgrading JET 4 (by manually replacing odbcjt32.dll in system32 and
system32/dllcache)
* Googled to death on the matter, but no others solutions were brought
up.

Hopefully someone can help us out, we're migrating to Windows 2003
Terminal services, and this application is mission-critical.

thx,

Serge

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.