Help about MS-Access

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

 

[Gary Miller]

Ashish,

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

SELECT * FROM tblClients

Gary Miller

 

[Sal]

Try this

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

Sal

 

[Gary Miller]

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

Gary Miller

 

[student3hw4f]

hallo!