1. Forum
  2. USENET
  3. comp.databases.ms-sqlserv

  • Opening an old sample of Access97 with MSoft Access365.

    From Peter Jason@pj@jostle.com to comp.databases.ms-access on Sat Aug 28 09:18:54 2021
    From Newsgroup: comp.databases.ms-sqlserv

    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.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Martin Hungerford@martinhungerford@gmail.com to comp.databases.ms-access on Sun Aug 29 15:48:28 2021
    From Newsgroup: comp.databases.ms-sqlserv

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From DiW@d.wiltsch@gmx.de to comp.databases.ms-access on Sun Jan 9 04:30:52 2022
    From Newsgroup: comp.databases.ms-sqlserv

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2