Show tables in an access db

[Caradog]

I know this can be done but can't find the code wherre I did it or remember how...I am trying to list all the tables in an access db to a web page...anyone help me out here?

- Jay
code@jay-hayman.co.uk

 

[dtqbterror]

The hidden system table MSysObjects contains the name of all of the tables in the database. To view this table go to
Tools>Options Then select the view tab and check the Hidden Objects and System Objects text box. You can run the following SQL Statment against you db to get the table names

SELECT name from MSysObjects WHERE type = 1 AND flags = 0;

Hope this helps.

 

[Caradog]

Ok, done that but can't work out how to set the table to have read permissions.

" Record(s) cannot be read; no read permission on 'MSysObjects'. "

- Jay
code@jay-hayman.co.uk

 

[Caradog]

Ah-ha! Not to worry, my fuddled lunch time pub relaxed brain found the User and Groups permissions and I can now read the table

- Jay
code@jay-hayman.co.uk