msaccess lite?

[Robert Blackwell]

looking for some kind of app to read and write msaccess tables. doesn't need
to edit table structure or make queries. Does anyone know if such a program
exists? its for an mdb that is on a remote server and i just need to check
some stuff every once and a while.

 

[Amy Blankenship]

Anything that can use an ODBC connection can do this, as long as you know
the table structure.

HTH;

Amy

 

[Robert Blackwell]

Yeah, but I dont know of any apps (preferably free/opensource) that can
connect to ODBC withouth trying to import or save as another format.
oh wait I just remembered I have open office and I just tested it can do
just that woohoo.

 

[Albert D.Kallal]

Well, every copy of windows XP ships with the JET engine that can open, and
read mdb files.

So, any VB program you write....even a windows script can actually open and
read a mdb file.....

If you paste the following windows script into a text file...and then
re-name it with the vbs extension, you can run it on any windows box...

Set dbeng = CreateObject("DAO.DBEngine.36")
strMdbFile = "C:\Documents and Settings\Albert\My
Documents\Access\ScriptExample\MultiSelect.mdb"
Set db = dbeng.OpenDatabase(strMdbFile)
strQuery = "select * from contacts"
Set rs = db.OpenRecordset(strQuery)
rs.movefirst
If rs.EOF = true Then
quit
End If

strTextOut = "C:\t5.txt"
set fs = Wscript.CreateObject("Scripting.FileSystemObject")
Set ts = fs.OpenTextFile(strTextOut, 2, True)
' 2 = write, 1 = read

do while rs.EOF = false
strOutText = rs("LastName")
ts.Writeline strOutText
rs.movenext
loop
ts.close
rs.close


So, you have the choice of virtually any development platform,and will be
able to read the mdb files.

You don't even need odbc here.....

And, if you don't have ANY platform, and even ZERO tools, then you can use
the above windows scripting.

So, windows XP ships with jet, and virtually ANY software tool that exists
should be able to open and use a mdb file.

You could use word, or excel here..but, you don't even need that!!! the
above example can be done on a computer with JUST notepad....