Groups > comp.databases.ms-access > #14302

Re: Count columns per table

From	RobertoA <amorosik@tiscalinet.it>
Newsgroups	comp.databases.ms-access
Subject	Re: Count columns per table
Date	2021-05-19 15:56 +0200
Organization	Aioe.org NNTP Server
Message-ID	<s835f6$1irv$1@gioia.aioe.org> (permalink)
References	(2 earlier) <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>

Show all headers | View raw

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?

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Count columns per table musicloverlch <lhowey@gmail.com> - 2021-03-22 10:50 -0700
  Re: Count columns per table Ron Weiner <rw@domain.com> - 2021-03-22 16:56 -0400
    Re: Count columns per table musicloverlch <lhowey@gmail.com> - 2021-03-23 06:31 -0700
      Re: Count columns per table Ron Paii <ron81pai@gmail.com> - 2021-03-24 06:11 -0700
      Re: Count columns per table Keith Tizzard <internet.shopping@foobox.com> - 2021-03-24 07:51 -0700
        Re: Count columns per table musicloverlch <lhowey@gmail.com> - 2021-05-17 14:18 -0700
          Re: Count columns per table RobertoA <amorosik@tiscalinet.it> - 2021-05-19 08:16 +0200
            Re: Count columns per table musicloverlch <lhowey@gmail.com> - 2021-05-19 06:53 -0700
              Re: Count columns per table RobertoA <amorosik@tiscalinet.it> - 2021-05-19 15:56 +0200

csiph-web