Message-ID:

The sooner all the animals are extinct, the sooner we'll find their money. -- Ed Bluestone

devel / comp.databases.ms-access / Re: Opening an old sample of Access97 with MSoft Access365.

Opening an old sample of Access97 with MSoft Access365.

<kksiigphq1m599bmes791ro11ouepenu2d@4ax.com>

https://www.novabbs.com/devel/article-flat.php?id=527&group=comp.databases.ms-access#527

copy link Newsgroups: comp.databases.ms-access

Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pj...@jostle.com (Peter Jason)
Newsgroups: comp.databases.ms-access
Subject: Opening an old sample of Access97 with MSoft Access365.
Date: Sat, 28 Aug 2021 09:18:54 +1000
Organization: A noiseless patient Spider
Lines: 9
Message-ID: <kksiigphq1m599bmes791ro11ouepenu2d@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="0c4f71d66cd5c7ff2e412be7f8c3035e";
logging-data="21058"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/3s3H3CNSbly/3o8klW53F"
User-Agent: ForteAgent/8.00.32.1272
Cancel-Lock: sha1:HhBo4Vzp+LXDTUL+nMUIdSMGJqE=

by: Peter Jason - Fri, 27 Aug 2021 23:18 UTC

I seek an example of an MSoft Access Bill of Materials (three levels)
software.

I think I found one, but it's for Access97 and cannot be opened in
Access MSoft 365.

Is there some way to fix this?

Please help since I'm hopeless with self-join queries.

Re: Opening an old sample of Access97 with MSoft Access365.

<1c6031a0-6dfa-4764-a12e-92d73435d055n@googlegroups.com>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=528&group=comp.databases.ms-access#528

copy link Newsgroups: comp.databases.ms-access

X-Received: by 2002:a05:620a:68c:: with SMTP id f12mr20133207qkh.363.1630277308984;
Sun, 29 Aug 2021 15:48:28 -0700 (PDT)
X-Received: by 2002:a9d:4916:: with SMTP id e22mr6356401otf.43.1630277308738;
Sun, 29 Aug 2021 15:48:28 -0700 (PDT)
Path: i2pn2.org!i2pn.org!news.niel.me!usenet.pasdenom.info!usenet-fr.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Sun, 29 Aug 2021 15:48:28 -0700 (PDT)
In-Reply-To: <kksiigphq1m599bmes791ro11ouepenu2d@4ax.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2001:388:6080:2e1:b9f8:3db6:d223:79dc;
posting-account=fLgGQgoAAAD6V2lwF7cufQhE_Euw6Iyr
NNTP-Posting-Host: 2001:388:6080:2e1:b9f8:3db6:d223:79dc
References: <kksiigphq1m599bmes791ro11ouepenu2d@4ax.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1c6031a0-6dfa-4764-a12e-92d73435d055n@googlegroups.com>
Subject: Re: Opening an old sample of Access97 with MSoft Access365.
From: martinhu...@gmail.com (Martin Hungerford)
Injection-Date: Sun, 29 Aug 2021 22:48:28 +0000
Content-Type: text/plain; charset="UTF-8"

by: Martin Hungerford - Sun, 29 Aug 2021 22:48 UTC

On Saturday, 28 August 2021 at 09:18:59 UTC+10, Peter Jason wrote:
> I seek an example of an MSoft Access Bill of Materials (three levels)
> software.
>
> I think I found one, but it's for Access97 and cannot be opened in
> Access MSoft 365.
>
> Is there some way to fix this?
>
> Please help since I'm hopeless with self-join queries.

The best bill of materials I've seen was in Celko's "SQL for Smarties" -but if you do not like self-join queries you will have trouble. Why does the A97 file not open?

Regards,
Martin

Re: Opening an old sample of Access97 with MSoft Access365.

<srdktd$6q1$1@solani.org>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=551&group=comp.databases.ms-access#551

copy link Newsgroups: comp.databases.ms-access

Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!reader5.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From: d.wilt...@gmx.de (DiW)
Newsgroups: comp.databases.ms-access
Subject: Re: Opening an old sample of Access97 with MSoft Access365.
Date: Sun, 9 Jan 2022 04:30:52 +0100
Message-ID: <srdktd$6q1$1@solani.org>
References: <kksiigphq1m599bmes791ro11ouepenu2d@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Sun, 9 Jan 2022 03:30:53 -0000 (UTC)
Injection-Info: solani.org;
logging-data="6977"; mail-complaints-to="abuse@news.solani.org"
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
Thunderbird/68.10.0
Cancel-Lock: sha1:xk9ozmMjzC6Z4Q6xV3HcvEHfNIs=
Content-Language: de-DE
In-Reply-To: <kksiigphq1m599bmes791ro11ouepenu2d@4ax.com>
X-User-ID: eJwVxckRwDAIBLCWsFmObQcw/ZeQiT4y9eMdcHPY2lLJV6OR1eJS/52rN9uCg8wirmjPUDBnowuX6493EfMBUlsVjA==

by: DiW - Sun, 9 Jan 2022 03:30 UTC

Am 28.08.21 um 01:18 schrieb Peter Jason:
> I seek an example of an MSoft Access Bill of Materials (three levels)
> software.
>
> I think I found one, but it's for Access97 and cannot be opened in
> Access MSoft 365.
>
> Is there some way to fix this?
>
> Please help since I'm hopeless with self-join queries.
>

Hi Peter,
you must have at least one Pc or virtual machine with an older Access.
The last version which was able to open ACC97 without problems is 2007,
maybe 2010.
So your steps should be:
- open the DB with Acc2003 and save in this 2003-format as mdb
OR
- open with Acc2007 so you can save to accdb.
This File is than readable from Acc2013 and higher.

Greetings
Dirk

Subject	Author
Opening an old sample of Access97 with MSoft Access365.	Peter Jason
Re: Opening an old sample of Access97 with MSoft Access365.	Martin Hungerford
Re: Opening an old sample of Access97 with MSoft Access365.	DiW