Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    8

    Question Unanswered: Modify data in SQL Server with access mdb

    hello

    I'm trying to use access to modify data in SQL Server 2000 tables. Everything is ok on most tables, but only one made me troubles. This one when I'm doing something on it is saying that an other user modify this record and I cannot save this information.

    This table has 40 rows and 3 primary key.

    I'm the only one to work on this database.

    thank you for response

  2. #2
    Join Date
    Jul 2002
    Location
    Glasgow, Scotland
    Posts
    7

    Wink Re: Modify data in SQL Server with access mdb

    Does your table have any bit data types which allow null values? Access can't deal with null value data bit columns and if you modify a row with a null value it gives you an error saying it has already been modified by another user.

    hope this helps

    Originally posted by anakin_ch
    hello

    I'm trying to use access to modify data in SQL Server 2000 tables. Everything is ok on most tables, but only one made me troubles. This one when I'm doing something on it is saying that an other user modify this record and I cannot save this information.

    This table has 40 rows and 3 primary key.

    I'm the only one to work on this database.

    thank you for response

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •