accessing old mdb file without using ms access

[mchoud]

Dear all

I would like to open or modifying my old mdb file, withoud using ms access, is there a way for do it,

Can i using dsn and how ?

Thanks
Kholid

 

[Pat Hartman]

There is no way. You need Access installed on your PC to modify an Access database.

 

[dcx693]

You can access the data inside an mdb file using VB, as described here using DAO: Intro to Using Access Databases in VB, but you cannot use or alter forms, reports, modules, or macros.

 

[mchoud]

manipulating mdb file without using vb or ms access

Dear all

Thanks about all of your reply regarding with this my question. The complete problem is, i have an instrument which generating mdb file that only which only can be edited by using ms access 2.0. When i tried to modifying by using Ms Access 97 or 2000, the ms access ask to converting to the current access version first.

If this file converted to the curent version of ms access, the instrument could not accepting the edited file although i save as the data into previous version.

Now, i am using Ms Excel 2000 and its query feature to modifying the database without changing data to any version. I decide this way because, i don't have enough knowledge about using VB or another programming language.

I have only little knowledge about sql query instruction.

Any way thanks once again all of your care for me.

Regards
mchoud

 

[Pat Hartman]

Rather than trying to open the A2.0 .mdb itselv, create a new .mdb with whatever version of Access you have and try to link to the A2.0 .mdb. If that works, you will be able to modify the table contents or get data out of them. A97 may be the last version to be able to read A2.0 files.