can anybody explain what the difference between the 2 codes below?
i'm using visual basic 6 and i'm connecting access dbase.
and one other thing, i'm trying to connect access 2007 with my vb6 but i can't remember the code, i know the code below works with access 2003 and that i'll just have to edit the code below, i also remember that instead of .jet it should be .ace other than that i can't remember what follows.
thanks for the help.
With caba .CursorLocation = adUseClient .Open "provider = microsoft.jet.oledb.4.0; data source=" & App.Path & "\DBASE\CABA.mdb;" End With With caba .ConnectionString = "Provider=microsoft.jet.oledb.4.0; data source=" & App.Path & "\DBASE\caba.mdb;" .Open End With