Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error in Access Database (Office 2000 / 2003)

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    I have been working and building my Access Database to track over thousands of Computer assets on a Military Installation, I have some how received an error on one of these many files. Now when I go to delete it, it states that I cannot due to it being used by another user? <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45> . I am the one and only that can touch this file. Please any help would be greatly appritiated.

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

    Re: Error in Access Database (Office 2000 / 2003)

    Do you mean that you want to delete a .mdb file? Try restarting your PC, sometimes Windows erroneously thinks a file is still in use after an application caused an error.
    Also, see if there is a file with the same name as the database but with extension .ldb instead of .mdb. If so, try to delete it.

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error in Access Database (Office 2000 / 2003)

    Hans
    I'm not trying to delete the whole Mdb file. This file is kept on an external Harddrive which is transported between work places. I have looked and the only .ldb opened is the one that I am currently working with. The problem is only one file on the table seems to be corrupted. I have to much data and work to start over. I only found it when I tried to do an export to .xls and it wouldn't allow it, I had to work around with the database to export what I needed.

  4. #4
    New Lounger
    Join Date
    Feb 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error in Access Database (Office 2000 / 2003)

    Thanks Hans
    I will give those a try. I appritiate your time, and yes LOL I back up my database almost on a daily basis. I just wish that I would have tried and fix it earlier since I have added other Base's onto this one and that's going to be a lot of import / exporting.. Will let you know how it goes.

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

    Re: Error in Access Database (Office 2000 / 2003)

    It appears that your database is slightly corrupt. Possible steps to repair it:

    Select Tools | Database Utilities | Compact and Repair Database...
    If that doesn't work, download and install the free utility JetComp.exe from Jet compact utility is available in download center. It comes with a manual. JetComp can repair some databases that the built-in command can't.
    If that doesn't work either, create a blank new database and try to import as many database objects from the problem database as possible.
    The last resort is going back to a recent non-corrupt backup. You do create backups regularly, don't you?

    PS To get the terminology straight, an Access database consists of only one file, the .mdb file. This file may contain tables, queries, forms, reports, macros and modules; those are not separate files, they are all stored in the single .mdb file.
    (This is a simplified description. Many developers split their database into a backend .mdb file containing tables and a frontend .mdb containing all other database objects.)

  6. #6
    New Lounger
    Join Date
    Feb 2003
    Location
    Jacksonville, North Carolina, USA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error in Access Database (Office 2000 / 2003)

    Hans

    That was great, just wish that I would have thought of the easy stuff first before asking. When I went and did the compact and repair it did it's thing. I then went in to see if it was still there, yes it was! The only difference was that this time I was able to delete it and save database.

    Again thanks for all your help

Posting Permissions

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