Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error message when opening database file

Status
Not open for further replies.

nqobile

Programmer
Aug 9, 2002
20
SZ
When opening my database the following message come up 'Microsoft Jet database engine could not find the object MSysDb. Make sure the object exists and that you spell its name and path name correctly'. What could be the problem and the resolution? The only thing I usually do is restore the database from Backup.
 
It looks as though you were trying (in your code somewhere) to reference a table called MSysDb. This table is not an access table, so it must have been created by the person who initially implemented your database, and has been misplaced. Try holding down the shift key before and during starting-up the database. This bypasses any startup settings, so no code will be run. If the system starts up fine - ie without the error, then you know its in the code somewhere. If that is the case, go into the VB code and do a search on the whole project for the word MSysDb. If you find it, you will be one step wiser. It may then be worth working out why this table is referenced.

Please let me know if this helps.
Mr Big.
 
I have the same exact problem as ngobile and your suggestion did not help. If you have any other I ideas, I'd appreciate them.

TIA, Jessica Morgan
Fire Fighter Sales & Service Co.
Pittsburgh, PA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top