Win2k & Access97 vs. Access2k

I am working on a multi-tier VB 6.0 application that uses an Access Database (currently 97) for reporting. The configuration works great on a WinNT4.0 machine with Access97. Even on a Win98 machine with Access97.

However, when installing the VB 6.0 application on a Win2k machine with Access97, the reports engine errors out with an unsupported library error. (Unfortunately, I don't have the exact error text with me at the moment.)

Same type of problem running on a Win2k machine with Access2k.

I have discovered one report that does run without error. It is the only report that does not involve creating an ADO Recordset and parsing through it. The lines where the error seems to occur are the following:

Set rst = qdf.OpenRecordset
rst.MoveLast

Does anyone know if there are issues running this type of module on Win2k with Access97 or on Win2k with Access2k? Any help would be greatly appreciated.

Probably the age old "Unrecognised database format"...

Make sure you've got the latest version of MDAC (www.microsoft.com/data) and SP5

I had the same problem, so I had to include an option to install the necessary files into the system folder. When you get the error message again, take note of the file. Maybe I have the application for you already :)

Good luck!