Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 AnswerThis

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-20 : 09:48:54
Atif writes "Plz tell me the query that can select the table name from the database. And the database type is mdb i mean in MsAccess.
I use Visualbasic.
plz answer this
i shall be very thankful to u."

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2002-03-20 : 10:44:31
Your question may be one to which this is an answer:

SELECT Name FROM MSysObjects
WHERE Type = 1 AND Left$(Name,4) <> "Msys"


Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-20 : 12:18:35
quote:

Your question may be one to which this is an answer:



Your comment definitely is the one about which I am laughing out loud!

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -