That's what I needed. Thanks very much!
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: Billy Cravens <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, September 18, 2000 8:35 PM
Subject: Re: [CF-Talk] RE: listing tables in Access?
>You must open the database in Access, and make MSysObjects readable
>(system table; lists objects that make up the db, including tables).
>Can't remember the exact menu sequence, but we're all smart here :)
>Then you can query that table. Very similar to sysobjects table in SQL
>Server.
>
>Here some quick queries that do the tricks you need:
>http://home.att.net/~dashish/queries/qry0002.htm (disclaimer: I spent 5
>seconds searching, so it's probably not the best out there)
>
>--
>Billy Cravens
>[EMAIL PROTECTED]
>
>
>
>Eron Cohen wrote:
>>
>> Once upon a time there was a tag in the Allaire Tag Gallery that did this
>> for MS Access. Unfortunately, it quit working when we we upgraded to
Access
>> 2000 or something like that (I forget exactly what went wrong). Just in
>> case it will work for you, it was called CFX_TABLEFIELDS.
>>
>> HTH,
>>
>> Eron
>>
>> -----Original Message-----
>> From: Jamie Keane [mailto:[EMAIL PROTECTED]]
>> Sent: Monday, September 18, 2000 1:38 PM
>> To: CFTalk
>> Subject: OT: listing tables in Access?
>>
>> Hello everyone,
>>
>> I was wondering if Access has some mechanism in place to list all tables
in
>> a database. Thanks.
>>
>> --
>> Jamie Keane
>> Programmer
>> SolutionMasters, Inc.
>> 9111 Monroe Rd., Suite 100
>> Charlotte, NC 28270
>> www.solutionmasters.com
>> 704.563.5559 x 228 Voice
>> 704.849.9291 Fax
>>
>> -------------------------------------------------------------------------
---
>> --
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
>> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>> the body.
>>
>> -------------------------------------------------------------------------
-----
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
