Error Message

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

Joe Williams

I get the following error message on a user's machine when they try to open
a database:

the Microsoft Jet Database could not find the object 'databases' Make sure
the object exists and that you spell its name and path correctly"

The database is a standalone MDB, and they are running on Windows XP, Access
XP, latest Internet Explorer.

Any thoughts on a cause and possible solution?
 
This evidently indicates a corrupt db.... This from Michael Noto MS
Support.....

methods to attempt recovery of the database:
===================================
1. Use the Compact and Repair tool to attempt the repair the database.
2. Create a new database, and try to import all the objects from the
original database.
3. Use JetComp.exe, the utility to repair the database.
4. Use MS Query to retrieve the data from the problem database.

To import all objects from your old database:
================================
1. With Access open, click File, New
2. Select database on the General Tab and click OK
3. Select location and a better name then db1, db2, etc. Click Create
4. We now have an empty database container. So we click File, Get External
Data, Import
5. Browse to the database, select it and click Import
6. The Import Objects window appears
7. We want to click 'Select all' for each Tab (Tables, Queries, Forms,
Etc..) then click OK.

Steps to use JetComp:
================
1. Double click jetcomp.exe to open the utility
2. Click the three dot builder next to 'Database to Compact From (Source)'
3. Browse to your database, select it, then click open
4. We now have the path to your database in the 'Database to Compact
From(Source)' textbox.
5. Click the three dot builder next to 'Database to Compact Into
(Destination)'
6. Browse to your database, select it, then click open
7. We now have the path to your database in the 'Database to Compact Into
(Destination)' textbox.
8. We must change the name so click in the textbox 'Into" and change the
name from MyDatabase.mdb to MyDatabase1.mdb
9. Select the button 'Destination is 3.x (97) or 4.x (2000/2002) database
format
10. Click the Compact button
11. When finished JetComp will say ready in the lower left-hand corner.
12. Open Access and click file, open, browse to where you saved the
database and open MyDatabase1

related articles:
===============
ACC2000: Jet Compact Utility Available in Download Center

http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database

http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

HOW TO: Keep a Jet 4.0 Database in Top Working Condition

http://support.microsoft.com/default.aspx?scid=kb;en-us;300216
 
Back
Top