Can not connect to Access DB via vb.net winForm

[Guest]

I have a VB .Net Windows application that accesses an Access Database using
ADO.Net OleDB .Net Data provider. Users are running Windows XP with the .Net
Framework installed. It works fine on user's PC who have MS Access
installed. However, when I distribute this to a user who does not have MS
Access installed, the program cannot open the connection. The database and
the executable are on the same machine.

The Access database contains tables only. The users will not access the
database directly. All IO is done thru the VB .Net application.I have a
license to distribute Access runtime, but do not want to do so if all I need
to do is set a reference to Jet (or some other dll) so that the required
files are included in the installation package. Is there some reference I
should set before deploying?

 

[Van T. Dinh]

You are only using the JET Back-End and JET engine is part of the Windows XP
OS so I don't think you need anything extra from the JET point-of-view.

More likely, your problem is related to how you access JET Tables from
VB.Net and in this case, your question may get more responses from a VB.Net
newsgroup rather than here (unless VB.Net users / respondents happen to
visit this newsgroup.).

 

[Guest]

I try there. Thanks!
--
enak

You are only using the JET Back-End and JET engine is part of the Windows XP
OS so I don't think you need anything extra from the JET point-of-view.

More likely, your problem is related to how you access JET Tables from
VB.Net and in this case, your question may get more responses from a VB.Net
newsgroup rather than here (unless VB.Net users / respondents happen to
visit this newsgroup.).