Opening mdb access file without access
I don't have access to Microsoft, but you want to open the mdb file, is there a way to do this?
The mdb file contains the SQL code that I need. it's just a file that connects to the remote database. I need to view the sql code
I tried to open the openoffice base but it only showed me a few tables. I can't see where the sql code is?
This VBScript will print the SQL statements from the stored queries in the MDB database.
Option Explicit Dim dbe Dim db Dim qdf Set dbe = CreateObject("DAO.DBEngine.36") 'change the next line to include the full path to your database Set db = dbe.OpenDatabase("C:\SomeFolder\YourDatabase.mdb") For Each qdf In db.QueryDefs If Left(qdf.Name,1) <> "~" Then Wscript.StdOut.WriteLine qdf.Name Wscript.StdOut.WriteLine qdf.SQL Wscript.StdOut.WriteLine String(20, "-") End If Next Set db = Nothing Set dbe = Nothing
I saved it as DumpQuerySQL.vbs and then executed it from the command line like this:
cscript DumpQuerySQL.vbs > querySQL.txt
"Access" through ADO.NET and pretty much anything else should do the trick.
Kindness,
Dan
The Jet driver included with most Windows versions can do this. You can use the Jet driver through your preferred provider or API (ODBC, ADO, ADO.NET). Even Excel supports it (open the file and select MDB).
visual studio can view and modify access databases through its data source functions.
You can also check out FlySpeed SQL Query which can query all database types on the fly
Have you tried openoffice base? I've had luck with this converting MDB files.