Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Access 97 locks SQL Server (Access 97)

    SQL Sercer locks up with an odbs error. Up to 8 users are adding records into the same SQL Server table.

    Does Access 97 lock pages in linked SQL Server tables.

    We have determined that it's not Access 97 causing the pronblem, but a couple of pcs have got Access 2003 no SP installed, which seem to be causing the problem.

    If so what is the workaround.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 locks SQL Server (Access 97)

    Without knowing what the error is, I;m guessing when you say the table in SQL Server is "locked" that means updates or adds don't get committed? I had an issue like this in an Access/SQL Server linked table setup and the resolution was to add a column in SQL Server with datestamp as the column type. This apparently helps SQL Server work with external systems making changes to it's tables.

Posting Permissions

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