Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

locking ldb

Discussion in 'Information Technology' started by ubu, Nov 11, 2005.

Tags:
  1. ubu

    ubu
    Expand Collapse
    Guest

    I'm using Ms Access 2003. Is it ok to use msldbusr.dll with 2003?

    What exactly does "suspect state" mean? What if some of user names are blank?
     
  2. Loading...

    Similar Threads Forum Date
    Unlocking the House of the Almighty Gurmat Vichaar May 5, 2009
    Sikh News Calif. county wrong in blocking Sikh temple: court (Reuters via Yahoo! News) Breaking News Aug 5, 2006

  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    ubu <ubu@discussions.microsoft.com> wrote:

    >I'm using Ms Access 2003. Is it ok to use msldbusr.dll with 2003?


    Not really. msldbusr.dll comes with the JetUtils package which is
    meant for Access 97/Jet 3.5 MDBs.

    >What exactly does "suspect state" mean?


    This is the biggest problem with using msldbusr.dll with Jet 4.0
    databases as you see this misleading comment. This always happens
    when you view an Jet 4.0 LDB entry when the user has exited the MDB.
    Cleanly or not.

    >What if some of user names are blank?


    Not relevant as there can be up to 255 users in an MDB so most of
    those entries will be empty.

    I'd suggest using the techniques relevant to Access 2000 or newer as
    described at
    http://www.granite.ab.ca/access/corruption/workstation.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page