System Tables in MS Access

S

savalco

It has been a while since I wrote SQL and I seem to have a had a brain
freeze... I want to choose a table name (that I created) in a drop down
combo... What table do I select from?? In oracle I believe it was
systables... thanks.
 
D

Douglas J. Steele

MSysObjects.

The specific query will be:

SELECT [Name]
FROM MSysObjects
WHERE [Name] Not Like "msys*"
AND [Type] In 1,4,6
ORDER BY [Name]

Type 1 is tables in the front end, Type 6 are linked tables, Type 4 are ODBC
tables.
 
S

savalco

wow that was quick!! Thanks for your help! Guess I am not the only amature to
have asked that Q!!
 
B

Big Man

What about for "syscolumns" what is the specific query for that?

Big Man


Douglas J. Steele said:
MSysObjects.

The specific query will be:

SELECT [Name]
FROM MSysObjects
WHERE [Name] Not Like "msys*"
AND [Type] In 1,4,6
ORDER BY [Name]

Type 1 is tables in the front end, Type 6 are linked tables, Type 4 are ODBC
tables.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


savalco said:
It has been a while since I wrote SQL and I seem to have a had a brain
freeze... I want to choose a table name (that I created) in a drop down
combo... What table do I select from?? In oracle I believe it was
systables... thanks.
Click to expand...
Click to expand...
 
D

Douglas J. Steele

Sorry, there isn't a syscolumns equivalent in Access.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Big Man said:
What about for "syscolumns" what is the specific query for that?

Big Man


Douglas J. Steele said:
MSysObjects.

The specific query will be:

SELECT [Name]
FROM MSysObjects
WHERE [Name] Not Like "msys*"
AND [Type] In 1,4,6
ORDER BY [Name]

Type 1 is tables in the front end, Type 6 are linked tables, Type 4 are
ODBC
tables.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


savalco said:
It has been a while since I wrote SQL and I seem to have a had a brain
freeze... I want to choose a table name (that I created) in a drop down
combo... What table do I select from?? In oracle I believe it was
systables... thanks.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Dropdown list that only displays options that are still available 11
Access 2007 - Table A lookup values based on Table B 1
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Query to return row count for each table (from MS Access) 20
oracle sql plus - modified table column - not showing in Access 1

Top