Plss! help me!!



How to Connect VB 6.0 to microsoft access database??

Welcome to A1vbcode nengyen.

Databases use different formats to access them. ADO, Adodc, OLE DB, ODBC, RDS, DAO, Jet, JRO, and the old Data control. ADO, DAO, Adodc and the Data control are the common ones used.

For connecting have a read here.

Keith

hai

dim conn as new adodb connection

dim rec as new adodb connection

both are declare in global variable

dim str as string

str="provider=Microsoft.jet.OLEDB.4.0;data source=";

conn.connnectionstring=str;

conn.open

rec.open(,conn);

example:

rec.open("select * from table1",conn)

This is a good question but I looked through here and realy did not see anything that taught me how to do this I am working on issue right now.

Keith I have seen some of all the comands or code functions you mentioned  and I sampled I think at least one of them but had no luck in learning anything new here.

Is there away and I dont mean to change the subject here by dropping off the using access program here and instead using other forms link in the background when this vb program runs? this seams like it would be so much easier 

 Hey looking for a puppy check out what we have www.kaycopets.com" target=_"blank" class="SmlLinks">www.kaycopets.com

Well you have to decide how you are accessing the database. With ADO, Adodc, OLE DB, ODBC, RDS, DAO, Jet, JRO, and the old Data control. ADO, DAO, Adodc and the Data control are the common ones used. Then you can access the correct page on the link I've provided.

Keith

sorry keith I have tried the instructions in the link you provided and I got an error saying it should be an end right after the .4 in that string can you give us some insight to this please

 Hey looking for a puppy check out what we have www.kaycopets.com" target=_"blank" class="SmlLinks">www.kaycopets.com