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.