Error problem

[Frank]

I have a multiuser Access front-end linked to tables in a Microsoft SQL
database application running in Windows under Citrix.

It has worked perfectly for years.

Recently network bandwidth was significantly reduced and errors began to
occur on a data entry form -

2473 - The expression |2 you entered as the event property setting produced
the following error: |1.@* 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.@@1@@1

3020 - Update or CancelUpdate without AddNew or Edit.

7878 - an SQL server error (I think) relating to two users changing the same
data at the same time

3197 - The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.

The last of these began to occur when Access 2003 was installed (still
running an Access 2000 front-end).

Two users are NOT concurrently trying to change the same record.

Another problem which has begun very recently is that (sometimes) when an
operator keys the first character into a field, "27" appears in the field ...
this happens before "Before Update" code has fired off ... might this be
something to do with ASCII 27 (Esc)?

It seems to me as if the update of one field in a record might not be
completed before a change to the next field commences and that causes a
conflict.

Does anyone have a similar experience or any ideas about what might be
causing all this?

Thanks in advance ...

 

[NTC]

that's alot of errors

I would remove all front ends and the single back end off line,
compress/repair both... put them back online with new links fresh...

may not solve a thing....but it is the first step I would take in a case
like this when there are so many moving parts...... if you have the luxury;
add front ends in increments as spaced apart in time as possible to watch
behavior along the way.....