I use Access 2000. I recently moved my databases to a new PC running Win XP from my old one running Win 2000. Win I try to run my VBA modules on the new PC, I get a "Class Not Registered" error on the following step:
rs.Open "[Table_Agent]", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
I originally had MDAC 2.5 on both PCs but downloaded and installed MDAC 2.8 on the new one while trying to fix the problem. I also downloaded the most current version of Jet. The CurrentProject.Connection appears to be the problem but I can't figure out why.
Any help would be greatly appreciated.
Scott
rs.Open "[Table_Agent]", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
I originally had MDAC 2.5 on both PCs but downloaded and installed MDAC 2.8 on the new one while trying to fix the problem. I also downloaded the most current version of Jet. The CurrentProject.Connection appears to be the problem but I can't figure out why.
Any help would be greatly appreciated.
Scott