help about MS-Access

[ashish potdaar]

Hello sir,

I am ashish from India. I have one query about Ms-
Access .I hope you will give me solution for that query.

My query,

Generally in Oracle when we want to see the all table
contain the database then we pass the qurey. "Select *from
tab" ,So i want to run this qurey in Access, I want to see
the all table in Ms-Access.So what qurey should i write.
Pls.send me solution for that.I am waiting your replay.
Thanking you.

From,
Ashish Potdar.
India.

 

[Jeff Boyce]

Ashish

Have you tried the same SQL statement in Access? There may be slight syntax
differences but it should work. I believe you need a semi-colon (";") at
the end.

Good luck

Jeff Boyce
<Access MVP>

 

[John Vinson]

Hello sir,

I am ashish from India. I have one query about Ms-
Access .I hope you will give me solution for that query.

My query,

Generally in Oracle when we want to see the all table
contain the database then we pass the qurey. "Select *from
tab" ,So i want to run this qurey in Access, I want to see
the all table in Ms-Access.So what qurey should i write.
Pls.send me solution for that.I am waiting your replay.
Thanking you.

Access is not as fully "relational" as Oracle: there is no Tab table
listing all the tables. That information is available using VBA code
(listing the members of the Tabledefs collection of the Database
object), or in cryptic and encoded form in the hidden MSysObjects
table. Try:

SELECT [Name] FROM [MSysObjects] WHERE [Type] = 1;

This will include all the (normally hidden) systems tables; to exclude
them use

SELECT [Name] FROM [MSysObjects] WHERE [Type] = 1 AND [Flags] = 0;

 

[Jeff Boyce]

Thanks, John. I like your response better!

Jeff Boyce
<Access MVP>