run SQL against mdb file without having MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don’t know if this is the right place to post this question.

I have a MS Access database file, but I don’t have MS access installed on my
machine. I want to run some SQL statements against this database. Is there
a SQL client software I can download so I can connect to the mdb file and run
queries?
 
To access data in a Access file (*.mdb), you do not have to have Access
installed, since the data access is performed by Jet Engine, which comes
with OS of all Windows version (you need to make sure latest Jet Engine
service pack is applied if the *.md file is produce with newer version of
Access, though).

You could find some free SQL Query tool on the net (I used one or tow of
them), MS Office (Pro version?) also comes with a SQL query tool (again, I
could not remember the exact name).

You can ues Excel to qury data in *.mdb file by clicking meny "Data->Import
external data..."

You can also program in VBA of all MS Office apps (Word, Excel...) or other
VBA-able App like AutoCAD to access data in *.mdb file. Of cource, if you do
programing with VB or other language, you are free to access data in *.mdb.
All of these do not need Access installed.
 
Back
Top