Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't open one of the Access Forms (2000)

    I can open most of the forms in an Access database that I'm trying to fix, but there are a couple of forms that are giving me trouble. When I click on them and click Design View, it boots me right out of Access then creates an Access.Lockfile.9 (SQL_BO.ldb). What's happening? I really need to get into this table because that is where the problem I need to fix is. I looked in the Permissions and I have permissions to Open/Run, Read Design, Modify Design, and Administer. So why can't I get in?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't open one of the Access Forms (2000)

    Have you tried to compact the database? (Tools | Database Utilities | Compact and Repair Database)
    Do you get any error messages when you do that?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't open one of the Access Forms (2000)

    I can open it now. Thanks, Hans. You're awesome!

  4. #4
    Star Lounger
    Join Date
    Nov 2005
    Location
    Edmonton, Alberta, Canada
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't open one of the Access Forms (2000)

    Just an observation - you will always get an ldb file when you open an Access database (unless you don't have write access to the directory the database is in). They're not obvious because when an Access database closes normally if no one else has the database open the ldb file is automatically deleted. You're seeing the ldb file because your database crashed.

Posting Permissions

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