I need to know how to set references in VB so that this connection (works fine on development machine) works on XP / Vista client machines.
I keep getting "Unrecognized database format" on client machines but it runs fine on my development machine.
All code is attached.
CODE
Private Sub Form_Load()
' for access 2007 only data1.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=DBQ=" & App.Path & "\testdb.accdb;DefaultDir=" & App.Path & "\;Driver={Microsoft Access Driver (*.mdb, *.accdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads
=6;UID=admin;UserCommitSync=Yes;"
' below for access 2003
data1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path$ + "\testdb.mdb;Persist Security Info=False"
data1.RecordSource = "select * from test"
data1.Refresh
' I also want the code to access using ado recordsets without the datacontrol
' showing a simple select query to get all records
' and one to delete all records
' here
End Sub
| 