Attempting to change same data same time

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Darryl
    #1

    Attempting to change same data same time

    I have an Access 2003 front-end tied via ODBC to a SQL Anywhere 8
    back-end.

    When I open a table & try to delete a record in a certain table, I get:

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

    I encounter similar problems in queries & forms, but diagnosing
    straight from the table seemed simplest to me.

    I also can't edit the record; when I do, it says that another user has
    made changes, and I only have the option to Drop Changes. Save Changes
    is grayed out.

    Needless to say, no one else is in either the front-end or the
    back-end. No problems in any other table. Removing foreign keys
    doesn't help.

    Tags: None
    • Darryl
      #2
      Re: Attempting to change same data same time


      Darryl wrote:[color=blue]
      > "The Microsoft Jet database engine stopped the process because you and
      > another user are attempting to change the same data at the same time."[/color]

      Never mind. Found it. Access boolean fields have only two states (0
      and -1 ie false & true) where ASA bit fields have 3 states (false,
      true, and NULL). The conversion program from MDB to ASA converted the
      boolean to bit properly initially, but newly added records were using a
      default of NULL for bit fields, which was confusing Access.

        Comment

        Previous template Next
        Working...