help about MS-Access

  • Thread starter Thread starter ashish potdaar
  • Start date Start date
A

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.
 
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>
 
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.
Click to expand...

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;
 
Back
Top