Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Locked thread
Fireshoes
Sep 7, 2000

Yes.....THAT Fireshoes

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.

Adbot
ADBOT LOVES YOU

Arsten
Feb 18, 2003



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?

Fireshoes
Sep 7, 2000

Yes.....THAT Fireshoes

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.

Arsten
Feb 18, 2003



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?

SpaceAceJase
Nov 8, 2008

and you
have proved
to be...

a real shitty poster,
and a real james


What kind of data does it contain, that you'd willingly send it to strangers?

Fireshoes
Sep 7, 2000

Yes.....THAT Fireshoes

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.

Arsten
Feb 18, 2003



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.

Woodsy Owl
Oct 26, 2004


Old rear end Access -> Excel -> New Access

Adbot
ADBOT LOVES YOU

thebigcow
Jan 3, 2001

Bully!

That loses any forms he's made.

Can LibreOffice Base open Access 97?

  • Locked thread