dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Feb 14, 2006

Find the Total Number of Tables in an MS Access Database

Use the following code to find the total number of tables in an MS Access database:

select count(name) from msysobjects where type=1 and flags=0
Jaya Nehru Kumar
 
Thanks for your registration, follow us on our social networks to keep up-to-date