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.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

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

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)