Post reply

Check for Open Record

  • December 17, 2002 at 7:56 am

    #158707

    I would like to check if a record is already in use from a SQL server using a linked table in Access 2000 before the user gets into the record.

  • December 17, 2002 at 8:10 am

    #444591

    I'm not 100% certain that this is the correct approach. You really should be using optimistic locking, and then testing to see if the row has been changed when you try to commit your changes. The last thing you want to do is start locking rows when you start to edit them...

    My other issue is that you're using Access - Access is not a multi-user development environment, even with a SQL back end - it just doesn't offer the functionality you need. If you want to stick with a database, use Visual FoxPro, otherwise VB etc.

Viewing 2 posts - 1 through 1 (of 1 total)

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