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

problem accessing access 97 database through odbc on windows 2003 sp1

P: n/a
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

ODBC Microsoft Access Driver Login Failed
Cannot open a database created with a previous version of your
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:
* 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
* Googled to death on the matter, but no others solutions were brought

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



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.