[AccessD] Previous Versions (was Thanksgiving)

[Jim Dettman]

<<- how do I open old mdb's to compact them so I can open
them with "Access for Microsoft 365" aka Office 16?>>

  You can't.   Since Access 2013, support for MDB's prior to version 4.0 was
dropped and the standalone JET compact no longer exists.

  You need to find someone with A2010 and prior to convert them for you.

  I can do that if you want.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Kathryn Bassett
Sent: Sunday, October 10, 2021 2:34 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: [AccessD] Previous Versions (was Thanksgiving)

Made me wonder how old some of mine are. In my Access folder I have a number
of subfolders. Near as I can figure out, my 3 oldest databases are Muir63
(Jan 1993), Books (Apr 1999); dates being the oldest "table created" date.
Books and Muir63 I can open as I keep those both up to date. However, I'm no
longer involved with the Angeles Crest 100 mile endurance race so I can only
open as far back as the "blank" copy of the 2003Ac100, and can't open some
in folder years older than that. I have a folder called 1998, but can't open
the AC100 (modified in 2010) or dsale (modified Jul 1998) mdb files to see
about the date of the oldest table in either of the mdb's in that folder
year.

I have other .mdb files that when I try to open them, I get:
Cannot open a database created with a previous version of your application
(Error 3041) Applies to: Access 2013 | Access 2016
You tried to access a database that is in an outdated format. Compact the
database and then try the operation again.

So, the question is - how do I open old mdb's to compact them so I can open
them with "Access for Microsoft 365" aka Office 16?

--
Kathryn Bassett (Pasadena CA)
kathryn at bassett.net
http://bassett.net   


> -----Original Message-----
> On Behalf Of Arthur Fuller
> Sent: Sunday, October 10, 2021 8:17 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Thanksgiving
<snip>
> AccessD is the best site I ever found to exchange ideas and problems with.
<snip>
> -- I wrote the original code in 2004! (How do I know this? Thanks to
MZ-Tools,
> which plants headers in your code that include StartDate, Aurthor, Purpose
> and so on.) When I look back, I think that trivial apps (those you can
write in a
> week or a month) have formed a small part of what I've written over my
> career.
<snip>
> I learned a ton from this list, and thanks to you all, I scaled mountains
I
> didn't think I could climb.
> This is Canadian Thanksgiving, and I thank you all! 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com