Ask a Question related to Coldfusion Database Access, Design and Development.
-
manylists #1
Re: list tables from Access 2000
What is the output variable?
Who do you give read permissions to?
Why would this need more permissons that a script that actually makes tables?
I think that would be done using the system account.
Thanks
Kieran Mullen
manylists Guest
-
Access 2000 or SQL Server 2000
Hi I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads... -
List Access database tables
I am using ASP and a MS-Access database. Can read and write to tables fine, but now I have a need to list all the tables in a given database. I... -
how I can get a list of tables with asp and access 2000
Hi guys, I have dsn connection to my access 2000 database and I am using clasic asp. So I wanna get a list of tables so, could you gelp me... -
Linking Informix tables to SQL Server 2000
I am having difficulty creating a linked server (Informix) in Microsoft SQL Server 2000. I have successfully installed the Informix OLEDB driver;... -
Adding Tables to a form in Access 2000
I created several tables and forms for the individual tables. I also created one additional form that would include data from all of the tables. ... -
paross1 #2
Re: list tables from Access 2000
Well, normally these "system objects" aren't "visible", nor are there any
permissions enabled on them. First thing you would do would be to select
Tools-->Options-->View and enable Show System Objects in Access. Then you could
select Tools-->Security-->User and Group permissions, and enable Read Data on
MySysObjects.
So you see, you would "need more permissons than a script that actually makes
tables".
Also, Not Like "MSys*" should be changed to Not Like 'MSys*' (single quotes)
in order to run from within a CFQUERY in CF.
Phil
paross1 Guest



Reply With Quote

