jet connect to access database with access installed

I've developed some stand-alone applications in VB6. They connect to an MS
Access database via a Jet connection. It works fine on the workstations that
have Access installed, but on the workstations without Access, it fails.

1. Are there reference libraries I can embed into the VB program?
2. Would an Access run-time version work, or does every station requrie a
full seat of Access?

If all you're doing is trying to get at the data in the Jet databases, there
should be no need to have Access (full or run-time only) installed on the
workstations.

All that should be necessary is to have a reference to the appropriate
library (DAO or ACE, depending on whether you're talking an MDB or ACCDB
respectively)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"BmlKidd" wrote in message
...
I've developed some stand-alone applications in VB6. They connect to an MS
Access database via a Jet connection. It works fine on the workstations
that
have Access installed, but on the workstations without Access, it fails.

1. Are there reference libraries I can embed into the VB program?
2. Would an Access run-time version work, or does every station requrie a
full seat of Access?

Thanks Doug, I thought I had the correct DAO reference already loaded but I
didn't (duh).

Anyway, I'm back in action.

Have a beer on me ...

"Douglas J. Steele" wrote:

If all you're doing is trying to get at the data in the Jet databases, there
should be no need to have Access (full or run-time only) installed on the
workstations.

All that should be necessary is to have a reference to the appropriate
library (DAO or ACE, depending on whether you're talking an MDB or ACCDB
respectively)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"BmlKidd" wrote in message
...
I've developed some stand-alone applications in VB6. They connect to an MS
Access database via a Jet connection. It works fine on the workstations
that
have Access installed, but on the workstations without Access, it fails.

1. Are there reference libraries I can embed into the VB program?
2. Would an Access run-time version work, or does every station requrie a
full seat of Access?

BmlKidd wrote:

Thanks Doug, I thought I had the correct DAO reference already loaded but I
didn't (duh).

To add to Doug's comments the Jet 4.0 DLLs come installed with Windows
XP and Windows Vista so there is nothing that should need installing.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/