Getting the Number of Tables in MS Access:

Getting the Number of Tables in MS Access:

Select count(*) from MSysObjects where Type = 1 and Flags = 0

Fetching Records from Closed DB.

Fetching Records from Closed DB.
SELECT * FROM Employees IN "C:\northwind.mdb";