Question Older version of database

[Henley12]

I am getting the following error when I try to open a database created in an older version of Access:

"The expression On Load you entered as the event property setting produced the following error: Object or class does not support the set of events."

This database is in the Access 2000 format, but it appears that 2007 tries to take over. Any ideas? I have several databases in the old format that I need to be able to maintain and I can't have this error popping up.

 

[NigelShaw]

Hi,

cant the databases be converted to 2007? alternatively, if you have more than one version installed on your PC, you can set your file associations.

Access 2000 opens .mdb
Access 2007 opens .accde

there is also a tool available on the net with a quick search that can sort this for you. i think it is on Tony d'ambra's site ( if thats the correct spelling )



Nigel

 

[Henley12]

I can't convert it to 2007 because the people who use it do not have 2007 on their machines. I can open it in 2007 without any problems, but when I try to open it with the older version, I get the errors. It appears to attach the Access 12 object library to the references. How do I open it without 2007 being involved whatsoever?

 

[Henley12]

Further explanation of the problem. We have a database in Access 2002 (2000) format that was getting the above error. I put the Access 12 Object Library in the references and it seemed to solve the problem for that database. However, we also have an Access 2007 database (runtime only) that will now not open properly. Are these two versions just not compatible, or is there some trick to this?

 

[boblarson]

Why do you have people with differing versions opening the same database file? What SHOULD be happening is that you should have a split database (frontend/backend) and the backend can stay in 2000 and then the frontend should be a copy on EACH user's machine. Then there is no conflict when someone with 2007 opens and someone with 2000 wants to open.

Multi-user use of Access really requires this setup or else you are at a VERY HIGH risk of corruption.

 

[Henley12]

These are two separate databases. One is written in the older version. The reason I can't convert it to 2007 is because Access Runtime doesn't allow mail merges. This person has the full version of Access 2002 on her machine to run the older database. She also has the Access 2007 Runtime version to run the 2007 database, which does not require any editing.

 

[boblarson]

She also has the Access 2007 Runtime version to run the 2007 database, which does not require any editing.

Who has 2007 (full version) in order to edit that database? Multiple versions of Access can work on the same machine but it gets a little tricky at times. Windows needs to run an "install" routine every time you use a different version. And if you happen to have Windows Vista it gets even more difficult as you have to set the MSACCESS.EXE files (both of them) to run as administrator so it can make the necessary registry changes.

 

[Henley12]

Still having a problem with this one. It appears when the 2007 runtime is loaded on a machine with an older full version of Access, the programs use the Access 12 object library, and I cannot change it.