K
KumbiaKid
I have a small app developed in Access 2000 which is used as a replicated db.
The Design Master remains on the 2000 machine. One replica is run on a
machine with Access 2003 and another on a machine running Access 2007. All is
well on the 2003 system. On the 2007 system, everything works just fine the
first time a newly created replica is opened (the replica is created directly
on shared folder on the 2007 system over a LAN). However, if the replica is
closed and re-opened, no code will run. For example, the main menu has a one
line On Open event procedure:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub
This works fine -- over and over -- until the DB is closed. Then, when the
replica is opened a 2nd or subsequent time, I get the following error:
"The expression On Open you entered as the event property setting produced
the following error: Object or class does not support the set of events.
* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro."
If I attempt any other action, such as an On Click event in a form to run a
query or anything else I've tried, I get very similar messages. Again, all
this code works on newly created replicas until the DB is closed and
re-opened.
It is my understanding that as long as the DB remains in .mdb format,
replication should work with Access 2007 and, by the way, changes made in the
Access 2007 replica merge back into the Access 2000 Design Master with no
problems even after the DB has been closed and code won't run on the 2007
machine.
One other thing. During development, I opened the Design Master over the LAN
with the Access 2007 machine for some demos and all was well. All machines
are running Win XP Pro with SP2.
Any ideas?
The Design Master remains on the 2000 machine. One replica is run on a
machine with Access 2003 and another on a machine running Access 2007. All is
well on the 2003 system. On the 2007 system, everything works just fine the
first time a newly created replica is opened (the replica is created directly
on shared folder on the 2007 system over a LAN). However, if the replica is
closed and re-opened, no code will run. For example, the main menu has a one
line On Open event procedure:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub
This works fine -- over and over -- until the DB is closed. Then, when the
replica is opened a 2nd or subsequent time, I get the following error:
"The expression On Open you entered as the event property setting produced
the following error: Object or class does not support the set of events.
* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro."
If I attempt any other action, such as an On Click event in a form to run a
query or anything else I've tried, I get very similar messages. Again, all
this code works on newly created replicas until the DB is closed and
re-opened.
It is my understanding that as long as the DB remains in .mdb format,
replication should work with Access 2007 and, by the way, changes made in the
Access 2007 replica merge back into the Access 2000 Design Master with no
problems even after the DB has been closed and code won't run on the 2007
machine.
One other thing. During development, I opened the Design Master over the LAN
with the Access 2007 machine for some demos and all was well. All machines
are running Win XP Pro with SP2.
Any ideas?