Unanswered: Strange behaviour when running app on different machine
I'm experiencing a strange problem when trying to run my access application on a different machine.
The VBA code runs fine until it hits the following command:
Set UserTable = CurrentDb().OpenRecordset("User", dbOpenDynaset)
I then get runtime error 429. I'm running the german version of access so I can't give you the exact english error description but it's something like "Object creation through activex component not possible"
Hmm, I'm a bit confused now. I don't have any version of visual basic installed on both systems (at least that's what the VBC6 installer tells me...). Apparently I don't need it either as the access application runs fine on the machine I developed it on...
Can I obtain an activex control package anywhere containing the comdlg32.ocx?
This ActiveX isn't used only in VB6, but also in the ODE-Tools, for example.
You can obtain a license patch for these ActiveX controls from Microsoft, as i said; but you need to know where you got this ActiveX's from, or install VB6 and then install the patch you already have.
Other suggestion: did you use >> dim db as DAO.database << ?