Error problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 ...
.

Relevant Pages

  • rookie restore and backup question(s)
    ... And apparently the backup file was corrupt. ... After the restore was finished failing ... really want to know if that database was broken before we got there. ... In my naivety I feel that Microsoft SQL ought to have attempted the restore ...
    (microsoft.public.sqlserver.server)
  • RE: SBSMonitoring Problem
    ... This issue may be caused if the database is corrupted. ... Reinstall SBS Monitoring if the above efforts do not work. ... Remove the Microsoft SQL Data Engine component. ... Server Desktop Engine from your computer, ...
    (microsoft.public.windows.server.sbs)
  • Problems with SQL server & asp
    ... I am using an asp page to access data stored by Microsoft SQL in a SQL server ... I am using IIS v5, Microsoft SQL Server 2000, running on Windows Advanced ... display blank although these fields hold text data in my test database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Problems with asp & SQL server
    ... I am using an asp page to access data stored by Microsoft SQL in a SQL server ... I am using IIS v5, Microsoft SQL Server 2000, running on Windows Advanced ... display blank although these fields hold text data in my test database. ...
    (microsoft.public.inetserver.asp.general)