Help about MS-Access

  • Thread starter Thread starter ashish potdar
  • Start date Start date
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.
 
Ashish,

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

SELECT * FROM tblClients

Gary Miller
 
Try this

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

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

Gary Miller
 
Back
Top