I've created a program that used an Access 2000 database and ADO controls. It works perfectly well on my machine, and any others that have Access 2000 installed. Problem is, not everyone here has Access 2000 - theres still alot on 97. When someone with 97 tries to run my program, it first displays an error "[ADODC] - Unknown error [ADO]" and after clicking OK displays another error "Run-Time error '429'. ActiveX component can't create object". It then rus the program, but nothing works (and I mean nothing - not even the exit button).

I guessed that it was because the database was an invalid version, so I tried to open it in Access 97 and sure enough it wouldn't work. I then saved it as a prior version on my machine, and using Access 97 i could then open the database. It still works fine on any machine with Access 2000, but same error with Access 97.

I'm thinking it may have something to do with .dll's but I have no idea where to start looking.

Any ideas??