development PC it works fine. I created a setup program so that I can
install this on other computers. Of source, I have to install the
..NET framework first. But when I run the program on the other PC it
does not find the DB, even when it displays the correct file string.
Here is what I tried and it does not work.
the operating system are all xp sp2
connection string:
Dim connString As String = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=0;Data Source=" & path & ";Jet OLEDB:Engine Type=5;Pro" & _
"vider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;p" & _
"ersist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:E" & _
"ncrypt Database=False;Jet OLEDB:Create System Database=true;Jet OLEDB:Don't Cop" & _
"y Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID" & _
"=admin;Jet OLEDB:Global Bulk Transactions=1"
thanks for helping

Access database
KMahon