Are we able to find all tables within the msaccess using sql .
once we do in sqlserver
select * from sys.tables
SELECT * FROM sqlite_master where type='table'
SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0
Ms Access has several system tables which are, automatically, hidden from tables list. You are able to demonstrate to them.
In Ms Access 2007 perform a right click tables list and choose
Navigation Options. At the end from the form you'll find
Show System Objects check box. Check it and system tables can have up in tables list. All of them begin with
Alternatively, options form could be triggered from application menu - click button
Access options -> choose
Current Database and there's
Navigation Options button.
You can now examine structure and contents and generate queries of system tables with MsAccess tools.
As Alex clarified, table details are in