[AccessD] Previous Versions (was Thanksgiving)

[James Button]

Paul,

Firstly,
 I would be reluctant to remove Access 2010 from my system - MS may no longer
allow it to be activated, or even installed from your CD media.
And remember NOT to allow the install to "Clean-up" as in delete the files
copied to the hard drive that will be needed for updating the app with fixes.
Secondly,  
In File Options of the 365 on my PC (was the 2016 that installed as part of the
365 subscription)
there is 
General - Creating databases - Default file format for a blank database  giving
options including 
Access 2000
Access 2002 - 2003 
Access 2007 - 2016
Object Designers - SQL Server Compatible Syntax (ANSI 92)

And in SaveAs
Access 2000 Database (*.mdb)
Access 2002-2003 Database (*.mdb)

Those may need to be set appropriately for 365 to handle the older database
formats
Could also be that the commandline is selecting he compact facility that is part
of the new version, and that is set to default to requiring files in the new
format 
Check the path to the earlier version of msAccess.exe is in the command line
calling MSAccess.exe

I tried a basic test - as in would the 2010 msaccess process the file - both a
version not updated since it was handled boy 2010, and a version that is current
declared by the msAccess to be in 2002-2003 format
 - by the 2016 version now updating the updated  .mdb

JimB

-----Original Message-----
From: AccessD
<accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of
Paul Wolstenholme
Sent: Sunday, October 10, 2021 9:18 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Previous Versions (was Thanksgiving)

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