Results 1 to 2 of 2

Thread: Record locking, ldb problem

  1. Aug 1st, 2000, 06:38 AM #1
    razamadaz
    razamadaz is offline

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Location
    N Ireland
    Posts
    10
    I have encountered a problem with the ldb file, one particular user seems to corrupt the file locking records and keeping a permenant connection open even when everyone is out of the database.

    Any ideas what is causing this one user to be the problem, he tells me he logs out of the program correctly.

    VB6,SP3,Access 2000
    Reply With Quote Reply With Quote
  2. Aug 1st, 2000, 07:02 AM #2
    Gary.Lowe
    Gary.Lowe is offline
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    razamadaz

    He tells you he logs out correctly.

    I would make sure he does.

    We had a similar problem where some users had a problem on thier pc and just CTRL+ALT+DELETE. This locked the database up.

    There is one way of releasing the locks by using the following
    Code:
    DBEngine.Idle dbFreeLocks
DBEngine.Idle dbRefreshCache
    This will release any locks

    Don't know if this is much help to you but I suppose every little helps.
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width