mouse click error

  • Thread starter Thread starter fredloh
  • Start date Start date
F

fredloh

i have a database on a server. all users run windows xp and access
2002. running the database from a pc that is not the development pc
gives the following error message whenever any button on the forms are
clicked.

the error message is "The expression on click you entered as the
event
property setting produced the following error: object or class does
not support the set of events"

some of the buttons is just a simple close form action yet clicking
them gives the error.

even if i don't run the database from the server but locally on the
pc, the same problem occurs. one way i found to
overcome the problem is to recreate the database on the pc giving the
problem but this is not the way i want the database to run.

what is the cause of the error message and how do i resolve it?

any help is appreciated.
 
Without seeing your database and code, it is impossible to pinpoint the cause
of the error. One thing, for sure, is that you should never run an Access
application from a server and more than one user should share a copy. Each
user should have a copy of the application on their own computer and be
linked to the data in an mdb file on a shared or network folder.
You need to also be sure that all users have the library files on their
computers that are identified in the VBA References.
 
Without seeing your database and code, it is impossible to pinpoint the cause
of the error. One thing, for sure, is that you should never run an Access
application from a server and more than one user should share a copy. Each
user should have a copy of the application on their own computer and be
linked to the data in an mdb file on a shared or network folder.
You need to also be sure that all users have the library files on their
computers that are identified in the VBA References.
Click to expand...

thanks for your reply. the problem actually also happens in another
access application.
i now have to go to each user's pc and recreate the database (and link
to the tables in an mdb file on the network folder)
 
Check the Library references in the VBA Editor (tools, references) on a
machine where it works an one where it doesn't and see if the references are
the same.
 
any reason why access application should never run off the server? i
thought it would updating of application a easy on step just like a
web site. has it got anything to do with record locking?
 
Running an application from a server doubles the network traffic. All the
processing takes place on the client, so having to retrieve the objects slows
the application in increases network traffic.
 
I'm getting the same error -- but it is with an .mde. Is there a way to
check the
references with that? The error doesn't happen in my development .mdb, nor
the
installed .mde on my machine.

DoCmd.close works for two buttons, and not for the third with a clean
install of the
..mde. The only difference I can see in the code is that the two that work
have an
event for both On Click and On Dbl Click, and the one that fails only has
the On Click. But, since I am single clicking anyway, and the error is
referencing the On Click, it appears to be a red herring.

How can I check the references on a .mde? Thank you for any help you can
provide.

-Karen
 
Back
Top