Access2000 error after viewing code in Access2002

[Laura]

Apologies for cross-post; not sure where to put this one.

My office has a database application written in Access2000
which I was requested to work on. It looks like it was
probably originally put together relying on some Access
wizards (i.e. has a switchboard layout I've seen in several
databases).

Using Access2002 (my only option; I do not have
Access2000), I reviewed the form design (including VBA
code) for several of the forms in the database, but only
made changes to a single report. I also added two select
queries. The database window says the database file is in
Access2000 file format.

This morning two staff members tried to use the database in
Access2000. One was not able to get into the database at
all. The other was able to open the database, but when
clicking on a button on the switchboard, received an error
"The expression on click you entered as the event property
produced the following error: automation error."

The latter staff member called me, and I opened the
database in Access2002(the database window still says it's
in Access 2000 file format) and found no problems. She
re-opened the database while I was in the database and
found no problems. BUT, when I closed out of the database,
she received the same error messages as before.

Leaving the database open in Access2002 for staff to be
able to use it is not a viable option. Any advice?

Thanks,
Laura

 

[Anne]

Needless to say, it would probably be helpful to have a copy of Access 2000.
The only problem that I have incurred using different versions, is that you
have to look at the libraries installed on every computer. If you distribute
the database, which you generated in access 2002, the default libraries
associated with the program will be the ones installed on your computer
which are version 10. But they have office 2000 installed, which is version
9. Examine the libraries on their computer and most likely the libraries on
their computer just have to be replace with version 9. This may have to be
done everytime to distribute the program.
There are website out there from these access gurus who developed files
where this can be done programaticly everytime you change the program. But
to start with, you need to find out where the problem is with your libraries
so you know what you are looking for to fix.