Access has encountered a problem

[CD Tom]

In my program I have an option to send information to an excel spread sheet. This works great except for one user, when ever he tries to run this option he gets the message "Microsoft Office Access has encountered a problem and need to close we are sorry for the inconvenience" it gives him the option to repair the database. I've got his data and run it on my system and don't get any errors. He is running Office 2000 and the Access program is using Access 2007. I don't think it has anything to do with my program but don't have any idea how to fix it. Does anybody have any suggestions.
Thanks for your help.

[NeoPa]

I've had a similar problem before.

When the database is last compiled on a system with one version, but then run under a different version, the best guess of which libraries to reference is made (when the exact version of one of the references is unavailable it tries to get the best match that is). You could try checking the references from your colleague's machine and for any that are Missing copy the files over from your machine to theirs.

[CD Tom]

Thanks for the reply. How do I check for missing references in a compiled version of my program? Question?? would my program even run if there were missing references?

[NeoPa]

All MDBs and ACCDBs are compiled when they're saved anyway, so we're not talking anything esoteric here.

1. From the main Access Window (Running on your colleague's PC) press Alt-F11 to switch to the VBA IDE.
2. Ensure your database is open.
3. Select Tools / References.
4. Any failed references are marged in the list with the word "Missing".

Your database would attempt to execute even if some references were listed as Missing. Yes.