Breakpoints in on-events of form

[Leigh]

I'm using Access 2002 .ADP connecting to SQL Server 2000.
I have created a number of forms which contains on-event
code. When I place a Breakpoint on the code and run from
the form, the code runs without stopping at the breakpoint.

 

[chas]

Hi Leigh,

Is the routine that has the breakpoint in it actually
running? (put a MsgBox in the event to see). Which event
(s) are you working with?

hth

chas

 

[chas]

Hi Leigh,

that particular error is associated with the following
text (as found in Jeterr40.chm jet error helpfile):
==============
You attempted to open a database that is already opened by
user <name> on machine <name>. Try again when the database
is available. (Error 3704)
This error occurs if the database is opened exclusively
and is not shared. This error occurs if a user creates a
new database in DAO, ADO, or Microsoft® Access and does
not close the database. Other users can open the database,
but they will get the above error message.

does that help?

Another possibility is that the breakpoint is set on a
line after where the error occurs. Try putting the
keyword 'Stop' (without quotes) at the beginning of the
routine.

hth

chas

============