Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Cannot find object 'databases'.

    Situation:
    Client is running a multi-user mdb file over network. Database worked correctly as of two days ago, but now opening the database file yields the following error:
    "The Microsoft Jet Database engine could not find the object 'databases'. Make sure the object exists and that you spell its name correctly."

    We recieve this same error when attempting to compact and repair the database, either over the network or locally.

    Any clues as to what is going on or how to resolve the issue?

    Thanks!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    That DB is more corrupt than the Mayor of Detroit!

    There's a utility out there somewhere called "JetComp" that's supposed
    to help in this area. I've never had to use it myself, so I can't vouch for it.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Yeah, I guess so. 'Cause when I used the JetComp utility I just get a message saying "Error compacting database".

    Hmph.

    I've never seen this before. Anybody else?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Just found out the user was using VPN into a desktop to access the mdb file located on a network. And that is when the corruption occured. So the corruption was probably caused by the network and may not be recoverable. Luckily, we have backups from the previous night.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Never say never ... Did you try an ODBC repair? If you need ask ... Search for ODBC Repair in this forum cause I've posted on how to do it before ...
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Thanks. I'll check that out for future reference.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    "Client is running a multi-user mdb file over network" - BE or FE?

    Anyway - as a last resort once you've exhausted all else and discover someone inputted a load of critical data right before your last backup:
    www.everythingaccess.com
    Wayne posts on this forum and is very impressive IMO.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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