I had to also go to Tools->Security->User and Group Permissions, highlight
'MSysObjects', and check 'Read Data' before this would work (Access 97).
This will solve problems I've had where I need to check for the existence of
a table, but does this open another can of worms? Am I opening up some kind
of security hole?
-- Owen
----
Athens County Library Services
http://www.athenscounty.lib.oh.us
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 4:17 PM
Subject: RE: Access table names
> You simply have to enable viewing of the system tables:
>
> Tools->Options->View
>
> ---
> Billy Cravens
>
> -----Original Message-----
> From: mr_urc [mailto:[EMAIL PROTECTED]]
>
> > You can get a list of all tables in an Access database by querying the
> > system tables. The system tables will all start with MSys. All of the
> > other
> > records returned by the query will be the rest of the tables in the
> > database.
> >
> > SELECT MSysObjects.Name
> > FROM MSysObjects
> > WHERE (((MSysObjects.Type)=1));
> >
> > This may not be the best choice, but it works.
>
> This seems to be what I was looking for. Unfortunately, I get this:
> "Record(s)
> cannot be read; no read permission on 'MSysObjects'." THWARTED AT EVERY
> TURN!
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
