If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unable to open MS Access '97 databse
When opening an Access '97 format database in Access 2007. I get the below
error: The Microsoft Office Access database engine could not find the object 'Database'. Make sure the object exists and that you spell its name and the path name correctly. Opening the same database in Access '97, I get: The Microsoft Jet database engine could not find the object 'Database'. Make sure the object exists and that you spell its name and the path name correctly. I have tried the standard repairs, compact. Even creating a new blank mdb and importing the tables / data without luck. Is there a way of saving / repairing this database ? If it matters. The mdb is just over 10mb in size. and other mdbs work fine. |
#2
|
|||
|
|||
Unable to open MS Access '97 databse
I don't believe that Access 2007 can open up an Access 97 database.
Tony Toews has an excellent web page on database corruption. Http://www.granite.ab.ca/access/corruptmdbs.htm Allen Brown also has excellent info on corruption. Http://allenbrowne.com/ser-47.html I have a white paper in a Word document named Fix Corrupt Access Database. Click on "Whittle, Jerry" on this page: http://www.rogersaccesslibrary.com/f...efault.asp?C=1 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "CJ" wrote: When opening an Access '97 format database in Access 2007. I get the below error: The Microsoft Office Access database engine could not find the object 'Database'. Make sure the object exists and that you spell its name and the path name correctly. Opening the same database in Access '97, I get: The Microsoft Jet database engine could not find the object 'Database'. Make sure the object exists and that you spell its name and the path name correctly. I have tried the standard repairs, compact. Even creating a new blank mdb and importing the tables / data without luck. Is there a way of saving / repairing this database ? If it matters. The mdb is just over 10mb in size. and other mdbs work fine. |
#3
|
|||
|
|||
Unable to open MS Access '97 databse
On Wed, 17 Mar 2010 07:02:01 -0700, CJ wrote:
When opening an Access '97 format database in Access 2007. I get the below error: The Microsoft Office Access database engine could not find the object 'Database'. Make sure the object exists and that you spell its name and the path name correctly. Opening the same database in Access '97, I get: The Microsoft Jet database engine could not find the object 'Database'. Make sure the object exists and that you spell its name and the path name correctly. I have tried the standard repairs, compact. Even creating a new blank mdb and importing the tables / data without luck. Is there a way of saving / repairing this database ? If it matters. The mdb is just over 10mb in size. and other mdbs work fine. Sounds like some seriously corrupt system tables. See http://www.granite.ab.ca/access/corruptmdbs.htm or http://allenbrowne.com/ser-47.html or both. There are commercial database salvage services which might be able to help (referenced at Tony's and Allen's sites). Some corruption is alas unrecoverable! -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Unable to open MS Access '97 databse
On Mar 17, 10:02*am, CJ wrote:
When opening an Access '97 format database in Access 2007. *I get the below error: The Microsoft Office Access database engine could not find the object 'Database'. *Make sure the object exists and that you spell its name and the path name correctly. Opening the same database in Access '97, I get: The Microsoft Jet database engine could not find the object 'Database'. * Make sure the object exists and that you spell its name and the path name correctly. I have tried the standard repairs, compact. *Even creating a new blank mdb and importing the tables / data without luck. Is there a way of saving / repairing this database ? If it matters. *The mdb is just over 10mb in size. *and other mdbs work fine. If you wrote your A97 databases in such a way that they can be converted to A2K format without error, use A2K, A2K2 (Office XP) or A2K3 (if available) to convert the file to the A2K or later format. Access 2K7 can run databases directly that are in A2K format and later, but not those in A97 format. A2K7 can still read links to tables stored in A97 databases. The A2K7 help for converting databases also suggests using an auxiliary A2K3 database in order to convert A2K7 databases back to A97. Note that the A2K database will have to be in a Trusted Location if VBA is involved. I don't like compromising the security of the computer that way, but I have not yet discovered a satisfactory workaround to having the database in a Trusted Location. James A. Fortune |
Thread Tools | |
Display Modes | |
|
|