Post reply

Update SQL table form Access

  • September 13, 2006 at 4:12 am

    #174218

    I have migrated a table from Access 2000 to SQL Server 2000.

    I am updating using DAO but the message keep telling me that anmother user is accessing the record. If I point to a linked access table I do not get the error 3197.

     

  • September 13, 2006 at 7:52 am

    #660094

    what exactly is the error message, and is it from sql or access?

  • September 13, 2006 at 11:55 am

    #660181

    How are you accessing the table (form, stored procedure, table view)? Does the linked table points to the sql 2000 table?

  • September 14, 2006 at 1:30 am

    #660302

    Do you have any bit fields in your SQL Table? SQL can handle nullable bit fields. Access can't however and will throw up a 3197 error whenever you try to do anything with the table.

  • September 14, 2006 at 3:27 am

    #660316

    Matt,

    Thanks very much you saved me several weeks of my life in searching for this.

    How did you know about this little gem.

    Thanks again.

    BB

     

  • September 14, 2006 at 7:18 am

    #660374

    Most likely by losing a few weeks searching for it .

  • September 14, 2006 at 11:12 am

    #660468

    how about months in my case!!

  • September 14, 2006 at 11:18 am

    #660471

    Just to give you an idea, it's only the 3rd or 4th time I see something like this in 2 years here .  So it's not a really know fact around here (but maybe it is on http://www.AccessMonster.com)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply