Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Power is danger. -- The Centurion, "Balance of Terror", stardate 1709.2

devel / comp.databases.ms-access / Re: Count columns per table

SubjectAuthor
* Re: Count columns per tablemusicloverlch
`* Re: Count columns per tableRobertoA
 `* Re: Count columns per tablemusicloverlch
  `- Re: Count columns per tableRobertoA

1
Re: Count columns per table

<d60e069a-9648-48d3-ada0-b0a42eae4e9en@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a37:ac0f:: with SMTP id e15mr1959629qkm.6.1621286292942;
Mon, 17 May 2021 14:18:12 -0700 (PDT)
X-Received: by 2002:a25:8711:: with SMTP id a17mr2694287ybl.219.1621286292692;
Mon, 17 May 2021 14:18:12 -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: Mon, 17 May 2021 14:18:12 -0700 (PDT)
In-Reply-To: <184abee0-2571-496a-9e08-120288b4cb97n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2601:2c7:8c00:9ab0:5506:792e:fd75:ed4a;
posting-account=Lr72qQoAAADkUv-gyUq0hiLVTj6vT-m8
NNTP-Posting-Host: 2601:2c7:8c00:9ab0:5506:792e:fd75:ed4a
References: <e12f6c3f-03c4-4967-a676-48c6fb707216n@googlegroups.com>
<s3b09d$9f0$1@dont-email.me> <55b0f4ef-939b-4581-ab56-6b65141f5dc9n@googlegroups.com>
<184abee0-2571-496a-9e08-120288b4cb97n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d60e069a-9648-48d3-ada0-b0a42eae4e9en@googlegroups.com>
Subject: Re: Count columns per table
From: lho...@gmail.com (musicloverlch)
Injection-Date: Mon, 17 May 2021 21:18:12 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: musicloverlch - Mon, 17 May 2021 21:18 UTC

I have a lot of linked tables and I wanted one list of how many columns they had in each table. Nothing had more than 100 so that's good. As for the db itself, the front end is about 200 MBs and the backend is split among five 1 to 1.5 GB databases. It is stable and has run fine for years.

Thanks everyone!

Re: Count columns per table

<s82ago$srj$1@gioia.aioe.org>

  copy mid

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

  copy link   Newsgroups: comp.databases.ms-access
Path: i2pn2.org!i2pn.org!aioe.org!VYr/u1gMygMZk6k+mfwTkQ.user.gioia.aioe.org.POSTED!not-for-mail
From: amoro...@tiscalinet.it (RobertoA)
Newsgroups: comp.databases.ms-access
Subject: Re: Count columns per table
Date: Wed, 19 May 2021 08:16:56 +0200
Organization: Aioe.org NNTP Server
Lines: 8
Message-ID: <s82ago$srj$1@gioia.aioe.org>
References: <e12f6c3f-03c4-4967-a676-48c6fb707216n@googlegroups.com>
<s3b09d$9f0$1@dont-email.me>
<55b0f4ef-939b-4581-ab56-6b65141f5dc9n@googlegroups.com>
<184abee0-2571-496a-9e08-120288b4cb97n@googlegroups.com>
<d60e069a-9648-48d3-ada0-b0a42eae4e9en@googlegroups.com>
NNTP-Posting-Host: VYr/u1gMygMZk6k+mfwTkQ.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.10.2
X-Notice: Filtered by postfilter v. 0.9.2
Content-Language: it
 by: RobertoA - Wed, 19 May 2021 06:16 UTC

Il 17/05/2021 23:18, musicloverlch ha scritto:
> I have a lot of linked tables and I wanted one list of how many columns they had in each table. Nothing had more than 100 so that's good. As for the db itself, the front end is about 200 MBs and the backend is split among five 1 to 1.5 GB databases. It is stable and has run fine for years.
>
> Thanks everyone!
>

1 to 1.5 of MDB / ACCDB files with data ?

Re: Count columns per table

<0d156a54-2ba5-4f97-8a15-78cf85ba73aan@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a05:6214:934:: with SMTP id dk20mr11507039qvb.26.1621432431956;
Wed, 19 May 2021 06:53:51 -0700 (PDT)
X-Received: by 2002:a05:6902:1243:: with SMTP id t3mr14930070ybu.402.1621432431627;
Wed, 19 May 2021 06:53:51 -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, 19 May 2021 06:53:51 -0700 (PDT)
In-Reply-To: <s82ago$srj$1@gioia.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=2601:2c7:8c00:9ab0:5486:2570:7a0:85aa;
posting-account=Lr72qQoAAADkUv-gyUq0hiLVTj6vT-m8
NNTP-Posting-Host: 2601:2c7:8c00:9ab0:5486:2570:7a0:85aa
References: <e12f6c3f-03c4-4967-a676-48c6fb707216n@googlegroups.com>
<s3b09d$9f0$1@dont-email.me> <55b0f4ef-939b-4581-ab56-6b65141f5dc9n@googlegroups.com>
<184abee0-2571-496a-9e08-120288b4cb97n@googlegroups.com> <d60e069a-9648-48d3-ada0-b0a42eae4e9en@googlegroups.com>
<s82ago$srj$1@gioia.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0d156a54-2ba5-4f97-8a15-78cf85ba73aan@googlegroups.com>
Subject: Re: Count columns per table
From: lho...@gmail.com (musicloverlch)
Injection-Date: Wed, 19 May 2021 13:53:51 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: musicloverlch - Wed, 19 May 2021 13:53 UTC

On Wednesday, May 19, 2021 at 1:17:02 AM UTC-5, RobertoA wrote:
> Il 17/05/2021 23:18, musicloverlch ha scritto:
> > I have a lot of linked tables and I wanted one list of how many columns they had in each table. Nothing had more than 100 so that's good. As for the db itself, the front end is about 200 MBs and the backend is split among five 1 to 1.5 GB databases. It is stable and has run fine for years.
> >
> > Thanks everyone!
> >
> 1 to 1.5 of MDB / ACCDB files with data ?

I don't quite understand what you are asking. The frontend database is about 100 megabytes and there are about 5 gigabytes of data in the backend. I have the 5 gigabytes split among 5 backend databases.

Re: Count columns per table

<s835f6$1irv$1@gioia.aioe.org>

  copy mid

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

  copy link   Newsgroups: comp.databases.ms-access
Path: i2pn2.org!i2pn.org!aioe.org!VYr/u1gMygMZk6k+mfwTkQ.user.gioia.aioe.org.POSTED!not-for-mail
From: amoro...@tiscalinet.it (RobertoA)
Newsgroups: comp.databases.ms-access
Subject: Re: Count columns per table
Date: Wed, 19 May 2021 15:56:55 +0200
Organization: Aioe.org NNTP Server
Lines: 14
Message-ID: <s835f6$1irv$1@gioia.aioe.org>
References: <e12f6c3f-03c4-4967-a676-48c6fb707216n@googlegroups.com>
<s3b09d$9f0$1@dont-email.me>
<55b0f4ef-939b-4581-ab56-6b65141f5dc9n@googlegroups.com>
<184abee0-2571-496a-9e08-120288b4cb97n@googlegroups.com>
<d60e069a-9648-48d3-ada0-b0a42eae4e9en@googlegroups.com>
<s82ago$srj$1@gioia.aioe.org>
<0d156a54-2ba5-4f97-8a15-78cf85ba73aan@googlegroups.com>
NNTP-Posting-Host: VYr/u1gMygMZk6k+mfwTkQ.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.10.2
Content-Language: it
X-Notice: Filtered by postfilter v. 0.9.2
 by: RobertoA - Wed, 19 May 2021 13:56 UTC

Il 19/05/2021 15:53, musicloverlch ha scritto:
> On Wednesday, May 19, 2021 at 1:17:02 AM UTC-5, RobertoA wrote:
>> Il 17/05/2021 23:18, musicloverlch ha scritto:
>>> I have a lot of linked tables and I wanted one list of how many columns they had in each table. Nothing had more than 100 so that's good. As for the db itself, the front end is about 200 MBs and the backend is split among five 1 to 1.5 GB databases. It is stable and has run fine for years.
>>>
>>> Thanks everyone!
>>>
>> 1 to 1.5 of MDB / ACCDB files with data ?
>
> I don't quite understand what you are asking. The frontend database is about 100 megabytes and there are about 5 gigabytes of data in the backend. I have the 5 gigabytes split among 5 backend databases.
>

When you say "..backend databases..", do you mean they are MDB or ACCDB
files?

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor