Manage MS-Access97 MDB files without having the full version of MS-Access installed

  • Thread starter Thread starter tivoli0
  • Start date Start date
T

tivoli0

Hello all,

I am looking for a freeware application to enable me to manage
Microsoft Access database files (like MDB or MDE) without having the
full version of Microsoft Access installed.

Thanks for any help.

-Tivoli0
 
tivoli0 said:
Hello all,

I am looking for a freeware application to enable me to manage
Microsoft Access database files (like MDB or MDE) without having the
full version of Microsoft Access installed.

Thanks for any help.

-Tivoli0

OpenOffice 2 will handle Access files.
 
You can view mdb tables/ queries by using other office products like
Word.
You can connect by ODBC which is provided by windows.

in Word using ODBC and Field codes , set up database connection field
code
3 items needed to use connection:
DSN: data name source as displayed in ODBC Administration
UID: user id to db server
PWD: password for uid to db server

the code is in the following format where '\c' and '\s' switch are
required:
\c "DSN=mydsn_here;UID=login_here;PWD=pwd_here" \s "my_select or query
here"


if you like more info email me, I have a document with instructions and
sample.
 
Back
Top