Can I distribute an MS Access mdb for interaction from MS Word VBA

[Ian B]

Hi All
As an alternative to a large ini file I would prefer to store constants in
an Access mdb and interact with the mdb via MS Word VBA..
It used to be, years ago, that if the user had any MSOffice product, then an
mdb could be accessed by any other VBA routine.

Is this still the case?

TIA.

Ian B

 

[Tom van Stiphout]

On Tue, 18 Nov 2008 17:33:26 +1300, "Ian B"

I don't think it ever was. Your question essentially is: On a virgin
machine, if I have VBA installed (by virtue of installing ONLY
MsWord), can I access an Access (better: JET) database? I think not.
You need to have DAO or ADO or ADO.NET installed to access the
database.

One simple way to get the DLLs to access the database is to first
install the free Access 2007 runtime.

-Tom.
Microsoft Access MVP

 

[Ian B]

Thanks for the reply Tom

I was more concerned with the licensing issues, and I didn't make this clear
in my original post.
In this case the user will have MSOffice standard installed, i.e. no MS
Access.

I will package by piggy backing on VB6 distribution/deployment package.
The access 2007 runtimes sound like a good backup if all else fails.

Thanks again

Ian B

 

[Tom van Stiphout]

On Tue, 18 Nov 2008 18:14:03 +1300, "Ian B"

If MsOffice, or any other app, has already installed DAO, ADO, or
ADO.NET, you can certainly re-use that for your own purposes without a
license issue.

-Tom.
Microsoft Access MVP