RunTime error 459 on current with database 2007 & 2002 conversion

[Lance]

I am experiencing an odd problem, and am hoping for some help.

I have a database that I designed in Access 2002. I then opened the
database in Access 2007 to ensure that everything was to be
compatible. Everything worked just fine in 2007. I then closed the
database, and reopened it in Access 2002, and things started going
wrong. On every call to VB, I now get error 459 - Object or Class does
not support the set of events. It does not matter the code - i get the
same error. This is occurring with the current, open, and click
events.

Any ideas? Did a reference library get messed up perhaps? I am not
sure where to even start with this one.

Thanks

 

[Allen Browne]

If this is on Vista (or on XP logged in as a limited user), see:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

 

[Lance]

If this is on Vista (or on XP logged in as a limited user), see:
    Errors using multiple versions of Access under Vista
at:
   http://allenbrowne.com/bug-17.html

Hmmm,

That seems close - however, I'm in XP as an admin with dual install- I
will, however, try the registry edit and see if that helps. I can see
in my reference library that it is attempting to run using the 12.0
references.

The confusing issue for me, is if I open an old database, it works
fine. It is ONLY the process of opening and closing a database in 2007
that causes the issue.

 

[Lance]

Hmmm,

That seems close - however, I'm in XP as an admin with dual install- I
will, however, try the registry edit and see if that helps. I can see
in my reference library that it is attempting to run using the 12.0
references.

The confusing issue for me, is if I open an old database, it works
fine. It is ONLY the process of opening and closing a database in 2007
that causes the issue.

This did not seem to resolve my issue.

I do notice, however, that I am completely missing the 9.0 reference
library now I tried to re-register it, and add it to the list, but it
will NOT let me have co-existing version of the main access library
for some reason. Thoughts?

 

[Allen Browne]

Create a new (blank) MDB in the version you want to use.
Make sure you have the appropriate version reference for the database you
are using.

Import everything into this database.

If you are not sure what version is appropriate, the table at the end of
this article might help:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hmmm,

That seems close - however, I'm in XP as an admin with dual install- I
will, however, try the registry edit and see if that helps. I can see
in my reference library that it is attempting to run using the 12.0
references.

The confusing issue for me, is if I open an old database, it works
fine. It is ONLY the process of opening and closing a database in 2007
that causes the issue.

This did not seem to resolve my issue.

I do notice, however, that I am completely missing the 9.0 reference
library now I tried to re-register it, and add it to the list, but it
will NOT let me have co-existing version of the main access library
for some reason. Thoughts?