My application (VB6) uses ADO 2.1 to access an MS-Access2000 database. I have set up an installation script using the Packaging and Deployment Wizard. Alas, on some (not all) machines the application installs and starts up fine, but returns and error when trying to access the database file for the first time. Some of my problem machines have Access2000, some do not, some are Win2000, some are Win98 or 95.
I have not included any other files in my installation than my own files and whatever P & D Wizard includes automatically.
Are my necessary run-time files out of date ? Is there a newer version of ADO I should be using instead ? I have heard that there are problems/bugs so that I should download a newer version, but what ? Is it enough to just e-mail a newer version to the user, or do I have to re-make the whole installation package ?
Appreciate if anybody could enlighten me about ADO and current affairs.