Problem saving record in multiuser environment.

  • Thread starter Thread starter Ron H
  • Start date Start date
R

Ron H

I've made an Access 2k program using forms, reports, and
queries. In one section it allows you to make
modifications to a record then saves it. This is a
multiuser program where people can log time into it
whenever they want to. Sometimes when editing and trying
to save a record I get this error...

The expression On Click you entered as the event property
setting produced the following error: The Save action was
cancelled. * The expression may not result in the name of
a macro, the name of a user-defined funtion, or [Event
Procedure]. * There may have been an error evaluating
the function, event, or macro.

I'm not sure why this error randomly pops up. The
database I am using is an MDE executable database. I
have record locking at the editing level. Is it possible
that someone has locking on the entire database enabled
on their Access 2k on their computer? Access is used
from each individuals computer. Any other suggestions?
Any help would be appreciated.

Thanks
Ron
 
Hi Ron,
this can happen when you have a single database file that
more than one user can open concurrently.

This is avoided by splitting the database into a front end
(queries, forms, reports, macros, modules) linked to a
back end (tables). Each user has their own copy of the
front end. Any data changes are saved in the common back
end.

Luck
Jonathan
 
Back
Top