1. Forum
  2. Usenet
  3. COMP.DATABASES.MS-ACCESS

  • Replacing a corrupted Query

    From Peter Jason@21:1/5 to All on Wed Jun 30 17:05:49 2021
    I suspect one of my queries is corrupted. Older ones from past
    backups work well, so I ask if I can replace the newer corrupted ones
    with the working older ones? How does one do this; is it just copy &
    paste? These are update, select, delete & make-table queries.
    P

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Cindy Krist@21:1/5 to All on Wed Jun 30 04:52:53 2021
    Peter,
    Go to a backup, display the query in SQL view, copy it.
    Go to the production database, create a new query, view it in SQL, paste it.
    If you go into Design view, you can move the tables around to make it more readable.
    Regards,
    Cindy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Peter Jason@21:1/5 to [email protected] on Thu Jul 1 07:24:06 2021
    On Wed, 30 Jun 2021 04:52:53 -0700 (PDT), Cindy Krist
    <[email protected]> wrote:

    Peter,
    Go to a backup, display the query in SQL view, copy it.
    Go to the production database, create a new query, view it in SQL, paste it. >If you go into Design view, you can move the tables around to make it more readable.
    Regards,
    Cindy

    Thank you Cindy, I'll report back with the results if any. There are
    many many queries to check.
    Peter

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Auntie Jack@21:1/5 to All on Wed Jun 30 23:00:15 2021
    Alternatively, import the queries from the old database. If you have 2016 or 365, that would be: External Data \ New Data Source \ From Database \ Access, If you have quite a few queries to import, that will make it quicker. Also, if one or more is
    corrupted, then you will probably find that Access interrupts the import when it encounters the corrupt one. That can make it easier to spot where the error is.
    Jack

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Peter Jason@21:1/5 to [email protected] on Fri Jul 23 17:24:27 2021
    On Wed, 30 Jun 2021 23:00:15 -0700 (PDT), Auntie Jack
    <[email protected]> wrote:

    Alternatively, import the queries from the old database. If you have 2016 or 365, that would be: External Data \ New Data Source \ From Database \ Access, If you have quite a few queries to import, that will make it quicker. Also, if one or more is
    corrupted, then you will probably find that Access interrupts the import when it encounters the corrupt one. That can make it easier to spot where the error is.
    Jack

    Thanks to all.

    The problem was not a corrupted query. It was when I coasted products
    in my 4-level BOM query I had neglected to filter out all levels
    except 0. This fixed the problem of cost duplicates.

    Thanks again.

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