I?m working on a family directory with a friend. She has created a database using access 2000 which contains names, addresses, phone numbers etc. I have access 97 on my computer. She gave me a floppywith the file on it: family.mdb, beside the access icon it says Microsoft Access Database 504kb. Everything looks normal, but when I try to open the file, I get get a box which reads :Unrecongnized database format. There is also a help button there. When I click on the help button I see the following:
Unrecognized database format <filename>. (Error 3343)
Possible causes:
· The specified file name is not a Microsoft Jet database.
· The specified file name is a device name, such as a printer, a console, and so forth.
· The .mdb file has invalid header information or an unknown sort order.
· A commit is pending from another user, but the lock file cannot be found.
· During a commit, you are attempting to write a Long value larger than the 2K maximum page size.
· The database is damaged. Repair and compact the database, and then try opening it again.
She copied it to a second floppy and also emailed me the file all with the same result on three diferent computers all running Office97. She is able to open the database on her computer. I thought you could open Office 2000 files using Office 97. I have installed Office97 SP1 and SP2 as well as Jet40Sp3_Comp.exe, since I read that Access2000 uses Jet 4.0 engine. Do I need to install Visual Studio Service Pack 4 or 5? Is there a way that my friend with Office2000 can save her data base files in a format that can be read on Office97 machines? BTW, I?m using WinXP Home Ed.
Thanks,
kev
Unrecognized database format <filename>. (Error 3343)
Possible causes:
· The specified file name is not a Microsoft Jet database.
· The specified file name is a device name, such as a printer, a console, and so forth.
· The .mdb file has invalid header information or an unknown sort order.
· A commit is pending from another user, but the lock file cannot be found.
· During a commit, you are attempting to write a Long value larger than the 2K maximum page size.
· The database is damaged. Repair and compact the database, and then try opening it again.
She copied it to a second floppy and also emailed me the file all with the same result on three diferent computers all running Office97. She is able to open the database on her computer. I thought you could open Office 2000 files using Office 97. I have installed Office97 SP1 and SP2 as well as Jet40Sp3_Comp.exe, since I read that Access2000 uses Jet 4.0 engine. Do I need to install Visual Studio Service Pack 4 or 5? Is there a way that my friend with Office2000 can save her data base files in a format that can be read on Office97 machines? BTW, I?m using WinXP Home Ed.
Thanks,
kev
Facebook
Twitter