Help about MS-Access

A

ashish potdar

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.
 
G

Gary Miller

Ashish,

Sounds very similar. If your table's name is "tblClients" it
would be...

SELECT * FROM tblClients

Gary Miller
 
S

Sal

Try this

SELECT MSysObjects.*, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Type)=1));

Sal
 
G

Gary Miller

Whoops, sounds like I misinterpreted the question. Thanks
for jumping in Sal

Gary Miller
 
Top