MSAccess97 and Windows2000

[mac_hua]

Hi. I have an application that will read and write to an Access97 database. This app works when it is run on a Windows9X OS. If I ran this on a Windows2000 computer, I receive an Obeject Cannot be Create error. I have included all the Access Run-Time files to the Windows2000 computer. The application does open and have a connection to the database. The error occurs when I try to create a recordset. The Windows2000 computer has Access2000 installed and running on NTFS. Any help is greatly appreciated.

[Iouri]

Try to reinstall MDAC_TYP.exe on W2000. That might cause the problem

Iouri Boutchkine
iouri@hotsheet.com

[coolbiz]

Which Database Access Object are you using? ODBC? ADO? DAO?. If I'm not mistaken RECORDSET object is in the Data Access Object component and if you're having a problem creating it, it probably because of versioning problem on the target computer.

-Cool Bizs

[mac_hua]

I'm using DAO.

[coolbiz]

I agree with reply from louri, try re-installing MDAC for Win2K. Do note that you do not need to have Access97 installed on target PCs. You just need the MDAC to be installed which will include the DLL needed to work with Access DB from your VB code.

It will also give you an error if on your development PC you have DAO 3.6 (higher version) installed but on the Win2K, you only have DAO 3.5 (older version) installed.

Also try to explicitly define the recordset object.
dim oRs as DAO.Recordset
set oRs = new DAO.Recordset

Hope it helps,
-Cool Bizs

[mac_hua]

I ran the MDAC_TYP.exe on the Win2K machine and it will not allow me to.

[coolbiz]

You can try to do the following:
1. Re-install MDAC 2.6 (downloadable from MS website http://www.microsoft.com/data/)
2. Use Package&Deployment wizard to pack your app and then try installing it on another Win2K machine.

-Cool Bizs