Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split DB (Access 2002 SP3)

    Good morning,

    I have a database that is split. I moved the backend and did a Link Table Manager to relink the tables. Upon exiting the database, I found that the backend.ldb was still present. It cannot be deleted or moved and will not close if I reenter the database and exit. Any thoughts? TIA.

    In addition, the database has a tab control with 5 tabs on it. If the database is not split, all tabs display subforms properly. With the database split, 2 of the tab controls do not display the subforms properly. Again, any thoughts? TIA.

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

    Re: Split DB (Access 2002 SP3)

    If the .ldb file is on a local disk, you may have to restart the PC. If it's on a network disk, try logging out and in again.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split DB (Access 2002 SP3)

    Hi Hans,

    Since the .ldb resides on a network drive, I tried logging off and in again to no avail.

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

    Re: Split DB (Access 2002 SP3)

    This happens to me from time to time. Usually, the locked file can be deleted the next day. If the problem persists, I have to ask the network admin to delete the file for me (but that is extremely rare).

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split DB (Access 2002 SP3)

    That's probably what I'll have to do also. Thanks for the reply. Any thoughts on the tab control issue?

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

    Re: Split DB (Access 2002 SP3)

    Sorry, "2 of the tab controls do not display the subforms properly" is far too vague to comment on. I'd need to have much more info or to see the database.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split DB (Access 2002 SP3)

    Unfortunately, this monster is not mine and I can't send it. I'll keep trying here. Thanks, anyway.

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

    Re: Split DB (Access 2002 SP3)

    Can you open the problematic subforms directly from the database window in the split database?

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split DB (Access 2002 SP3)

    No I cannot. The author of this is checking other forms for some key; Home-grown security. I'm going to send it back to him. Thanks again.

Posting Permissions

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