CODEWITHSUNDEEP
ms-accessms-access-2000
Thomas Koh
Thomas Koh

Reputation: 333

How do I connect to ms access database using sql management tool or any other tool?

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.

Upvotes: 0

Views: 326

Answers (1)

Tonner Mààn
Tonner Mààn

Reputation: 133

Why would you use MS Access 2000 ? this is 2018 haha Well if you're as unlucky as I am and your company have old databases and you're stuck with that there are other ways, I'm using MS Access 2003 to open those databases and I use Queries to execute SQL Code, I have MS Access in frensh so here is a screen shot to help Queries in MS Access 2003

You only have to create a new query or edit an old one, then siwtch to SQL mode like this: Switch to SQL Mode

I'm not sure but I guess you can use the same for MS Access 2000, if you want to use SQL Server you'll have to import data so you'll be no longer working on MS Access !!

Upvotes: 0

Related Questions