Is it possible to use *.mdb without MSAccess

[JSLUIS]

Hello everybody,

I have created a database program in Visual Basic. It uses the Microsoft Access-database (*.mdb). To use this database format I have installed Microsoft Access. Is it possible to install the *.mdb file format and use it with Visual Basic without installing MS Access?

Thanks in advance,
Jaap Sluis

 

[johnwm]

Providing that you do all your data access functions through DAO or ADO, and don't reference the Access Object Library in your project, there is no problem with using the Jet (.mdb) database format from VB. You can freely distribute the MDAC (Microsoft Data Access Components), subject to the EULA.

What you can't do is redistribute Access.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[zyrag]

johnwm, would still this holds true in Access databases with linked tables (source is a text file)?

 

[johnwm]

AFAIK reading from a textfile is done via one of the standard drivers. In general if you've written the app in VB6 without using the Access X.0 object Library then you're OK.

If in doubt, check with your EULA. There is also a full list of the redistributable components in a file called redist.txt which MS send out with all their apps.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'