[AccessD] Previous Versions (was Thanksgiving)

[Paul Wolstenholme]

Jim,

Looking at Kathryn's error message, I'm wondering whether the command line
compact option in newer versions of Access has also dropped support for
older Access versions.
https://www.access-programmers.co.uk/forums/threads/command-line-switches.176511/

[I'm still developing in Access 2010 but that will change soon - after my
client's last computer is upgraded.]

Paul Wolstenholme

On Mon, 11 Oct 2021 at 07:59, Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

> <<- 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>