Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Never trust an operating system you don't have sources for. ;-) -- Unknown source

devel / comp.databases.ms-access / Re: Replacing a corrupted Query

SubjectAuthor
* Replacing a corrupted QueryPeter Jason
`* Re: Replacing a corrupted QueryCindy Krist
 `* Re: Replacing a corrupted QueryPeter Jason
  `* Re: Replacing a corrupted QueryAuntie Jack
   `- Re: Replacing a corrupted QueryPeter Jason

1
Replacing a corrupted Query

<to5odg9ib8q1u1d443hlo1l2oioijf4grj@4ax.com>

  copy mid

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

  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: Replacing a corrupted Query
Date: Wed, 30 Jun 2021 17:05:49 +1000
Organization: A noiseless patient Spider
Lines: 5
Message-ID: <to5odg9ib8q1u1d443hlo1l2oioijf4grj@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="9067cf3f97ff3246d2f2c94c2deff95a";
logging-data="18005"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX180KIMbSuRIOhPhTbRMmshQ"
User-Agent: ForteAgent/8.00.32.1272
Cancel-Lock: sha1:5U/GJoX2KT2a3q6nkM40M8/TlHI=
 by: Peter Jason - Wed, 30 Jun 2021 07:05 UTC

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

Re: Replacing a corrupted Query

<3c62f390-6295-48d2-bd8e-b09a31f19d17n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:ac8:5cd5:: with SMTP id s21mr14417498qta.192.1625053974282;
Wed, 30 Jun 2021 04:52:54 -0700 (PDT)
X-Received: by 2002:a25:9904:: with SMTP id z4mr8897462ybn.481.1625053974052;
Wed, 30 Jun 2021 04:52:54 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!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: Wed, 30 Jun 2021 04:52:53 -0700 (PDT)
In-Reply-To: <to5odg9ib8q1u1d443hlo1l2oioijf4grj@4ax.com>
Injection-Info: google-groups.googlegroups.com; posting-host=72.74.84.234; posting-account=aD5szwoAAABb__OwpgcFTqRK5TPVKp1O
NNTP-Posting-Host: 72.74.84.234
References: <to5odg9ib8q1u1d443hlo1l2oioijf4grj@4ax.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3c62f390-6295-48d2-bd8e-b09a31f19d17n@googlegroups.com>
Subject: Re: Replacing a corrupted Query
From: cin...@smbpartners.com (Cindy Krist)
Injection-Date: Wed, 30 Jun 2021 11:52:54 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Cindy Krist - Wed, 30 Jun 2021 11:52 UTC

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

Re: Replacing a corrupted Query

<m5opdg544uqnl1ulo6bmgidgsi0a2m7hhs@4ax.com>

  copy mid

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

  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: Re: Replacing a corrupted Query
Date: Thu, 01 Jul 2021 07:24:06 +1000
Organization: A noiseless patient Spider
Lines: 13
Message-ID: <m5opdg544uqnl1ulo6bmgidgsi0a2m7hhs@4ax.com>
References: <to5odg9ib8q1u1d443hlo1l2oioijf4grj@4ax.com> <3c62f390-6295-48d2-bd8e-b09a31f19d17n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="9067cf3f97ff3246d2f2c94c2deff95a";
logging-data="16401"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+8JNSPTQXtoMhxXHkLn+56"
User-Agent: ForteAgent/8.00.32.1272
Cancel-Lock: sha1:+1Z2Fmtj2DmwasnFAsJd6vUNN0Q=
 by: Peter Jason - Wed, 30 Jun 2021 21:24 UTC

On Wed, 30 Jun 2021 04:52:53 -0700 (PDT), Cindy Krist
<cindy@smbpartners.com> 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

Re: Replacing a corrupted Query

<8476ea4d-34d3-4b4b-a0e5-3e9cac25033fn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a37:59c7:: with SMTP id n190mr40063109qkb.146.1625119215986;
Wed, 30 Jun 2021 23:00:15 -0700 (PDT)
X-Received: by 2002:a25:bd4f:: with SMTP id p15mr29552243ybm.338.1625119215584;
Wed, 30 Jun 2021 23:00:15 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!news.mixmin.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: Wed, 30 Jun 2021 23:00:15 -0700 (PDT)
In-Reply-To: <m5opdg544uqnl1ulo6bmgidgsi0a2m7hhs@4ax.com>
Injection-Info: google-groups.googlegroups.com; posting-host=58.167.166.142; posting-account=GI4SagoAAAB15s2MiJpjpOVBdFDm3Apz
NNTP-Posting-Host: 58.167.166.142
References: <to5odg9ib8q1u1d443hlo1l2oioijf4grj@4ax.com> <3c62f390-6295-48d2-bd8e-b09a31f19d17n@googlegroups.com>
<m5opdg544uqnl1ulo6bmgidgsi0a2m7hhs@4ax.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <8476ea4d-34d3-4b4b-a0e5-3e9cac25033fn@googlegroups.com>
Subject: Re: Replacing a corrupted Query
From: raycorb...@gmail.com (Auntie Jack)
Injection-Date: Thu, 01 Jul 2021 06:00:15 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: Auntie Jack - Thu, 1 Jul 2021 06:00 UTC

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

Re: Replacing a corrupted Query

<nerkfg18kcfu7otj0ocpi5fecmf87o26h1@4ax.com>

  copy mid

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

  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: Re: Replacing a corrupted Query
Date: Fri, 23 Jul 2021 17:24:27 +1000
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <nerkfg18kcfu7otj0ocpi5fecmf87o26h1@4ax.com>
References: <to5odg9ib8q1u1d443hlo1l2oioijf4grj@4ax.com> <3c62f390-6295-48d2-bd8e-b09a31f19d17n@googlegroups.com> <m5opdg544uqnl1ulo6bmgidgsi0a2m7hhs@4ax.com> <8476ea4d-34d3-4b4b-a0e5-3e9cac25033fn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="9a9fbd8b4aeb529bbab25fc72ebc225b";
logging-data="13373"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+7hjhP/rMNedqH7JLEDYjY"
User-Agent: ForteAgent/8.00.32.1272
Cancel-Lock: sha1:SZRpAqP8I8nOhTJWUwmZjx74z9o=
 by: Peter Jason - Fri, 23 Jul 2021 07:24 UTC

On Wed, 30 Jun 2021 23:00:15 -0700 (PDT), Auntie Jack
<raycorbin1@gmail.com> 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.

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor