vb program and ODBC driver

[jsa1981]

I want to create a VB program that access an Access Database backend
using an ODBC driver. This program and db file will be shared to
different people on different computers on a protable drive.

My questions are:
1. Will every computer that uses this program need Access to be
installed on it?

2. Will every comptuer that uses this program need the ODBC driver
installed on it? If yes, then is there anywhere I can download this
driver and provide it to the user?

3. Can anyone see any possible pitfalls in this design?

thanks in advance

Jagdip Singh Ajimal

 

[Van T. Dinh]

1. It sounds to me that you only needs JET (database engine) and not
Access. Furthermore, JET is part of the Windows OS.

2. VB can use JET natively so you don't even need to use ODBC driver.

Suggest you check your VB documentation first.