Please Help!! Jet database engine could not find the object messa

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have about 70 users on the DB and about 8 of them can not run a command to
print a report. They get the message "The Microsoft Jet Database egnine
could not find the object*. Make sure the objects exists and that you spell
its name and the path correctly." I know that it is working on the majority
of the users and yet these 8 are preplexing me to say the least since I have
tried to correct this but with no sucess. I guess you can say I am desperate
for any help!
 
So the code works for 60 odd users, but fails for 8? The solution will
involve tracking down what's different for those 8.

1. For starters, make sure the Name Autocorrect options are unchecked under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
Then compact the database.

2. If that doesn't solve it, try a decompile. Make a backup copy of the
file. Decompile the database by entering something like this at the command
prompt while Access is not running. It is all one line, and include the
quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then open Access (holding down the Shift key if you have any startup code),
and compact again.

3. If multiple users open the same database, splitting and giving a
*separate* front end to each user may solve the problem. If that's a new
concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

4. Still stuck? Examine the version of msaccess.exe (whereever you installed
Program Files\Microsoft Office\Office) and msjet40.dll (typically in
windows\system32.) Right-click in the Windows Explorer, choose Properties,
and look on the Version tab. If necessary, apply the service packs from:
http://support.microsoft.com/sp/
(The JET update is under Developer Tools.)

Post a reply if you're still stuck, and indicate the version details.
 
Back
Top