I am new to ms access database and I am using ms access 2000.
From the insert query menu from ms access, I cannot directly use sql queries command
e.g select * from table;
I have microsoft sql database management tool but not sure how to connect directly to ms access to query ms access database tables.
Anyone has any idea how to to that? Any sql tool software recommendation that can directly access ms access database table using sql queries command will also help.