jet connect to access database with access installed

[BmlKidd]

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?

 

[Douglas J. Steele]

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)

 

[BmlKidd]

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 ...

 

[Tony Toews [MVP]]

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/