|
I've got an old access 97 database that I'd still like to use. Regular conversion paths not working. Would like it to work on Win7 box with Access 2010 or newer. Can someone take a look at it and be my hero? Slightly over 200mb. Let me know preferred method of delivery.
|
#
?
Jul 14, 2016 17:35
|
|
|
|
| # ? Jan 31, 2023 10:42 |
|
|
You need to find a copy of Access 2003, open the database, and then go to Tools -> Convert Database and save as an Access 2003 database. This will then be able to be used by 2007 to 2010 in the mob format. If you wish to up-convert to the 2010 format, you'd need to then open it with an Access 2007+ version and save as the ACCDB format. Unfortunately, the JET driver from Access 2007+ doesn't support the Jet 3.1 format from 1997. Would you be able to find and use a copy of Access 2003?
|
|
#
?
Jul 14, 2016 18:07
|
|
|
I found a copy of Access 2003 and it will only let me convert to Access 2000 file format. Even with or without doing that the database is non-functional.
|
|
#
?
Jul 14, 2016 18:19
|
|
|
Fireshoes posted:I found a copy of Access 2003 and it will only let me convert to Access 2000 file format. Even with or without doing that the database is non-functional. How is it non-functional? Are the tables gone? The user-interface forms? The queries? Did the database get corrupted? How did you use it before you posted here for help?
|
|
#
?
Jul 14, 2016 18:27
|
|
|
What kind of data does it contain, that you'd willingly send it to strangers?
|
|
#
?
Jul 15, 2016 12:23
|
|
|
SpaceAceJase posted:What kind of data does it contain, that you'd willingly send it to strangers? Clearly nothing of any significance. Merely a helpful organizational database.
|
|
#
?
Jul 15, 2016 15:00
|
|
|
Fireshoes posted:Clearly nothing of any significance. Merely a helpful organizational database. You have too much porn if you have been keeping an Access database since 1997 to organize it.
|
|
#
?
Jul 15, 2016 16:36
|
|
|
Old rear end Access -> Excel -> New Access
|
|
#
?
Jul 16, 2016 15:09
|
|
|
|
| # ? Jan 31, 2023 10:42 |
|
|
That loses any forms he's made. Can LibreOffice Base open Access 97?
|
|
#
?
Jul 16, 2016 15:51
|
|
