suggestions in connecting to an access database?

[jaz215]

Hi everyone,

i'm using an access database and the way i access it is thru an odbc systemdsn. but this time i don't want to use an odbc since when i install the program to other computers i have to keep on setting up the odbc how do i overcome this? any suggestions on what should i use instead?

[Muiz]

Hi,

May be you can try using ADODB recordset.

Dim con As ADODB.Connection
Dim rs As ADODB.Recordset
 
Set rs = New ADODB.Recordset
Set con = New ADODB.Connection
con.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=\\wangmod2\Database\Col AMS.mdb;" & "Jet OLEDB:Database Password=compaq"
con.Open
rs.Open "SELECT Username From Login;", con, adOpenDynamic, adLockOptimistic
 
...
....
rs.close
con.close
 

try this and let me know if you face problems.

[CyberSoftHari]

This type of code, you have to create exe for each time when the database path changed.
Write connection string in text file and read it from there. This will be easy.

[jaz215]

Thanks a lot you two :D

it really helped me... ;P