
July 23rd, 2003, 11:08 AM
|
|
Contributing User
|
|
Join Date: Jul 2003
Posts: 33
Time spent in forums: < 1 sec
Reputation Power: 6
|
|
|
How to avoid having to refresh my Database connection every Time.
How to avoid having to refresh my Database connection every Time.
This is the code generated by Windows.
It seems like every time I change the folders name I need to refresh my Database connection, how can I avoid this how Can I change this code to have the program always look in the applications folders named DATA rigth on the application's path?
code:--------------------------------------------------------------------------------OleDbConnection1
Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDBatabase L" & _
"ocking Mode=1;Data Source=""C:\Documents and Settings\Telemetrika.Com\My Document" & _
"s\Zanussi Brio 250 Software\Data\BrioDatabase v1.3.mdb"";Mode=Share Deny None;Jet" & _
" OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System databas" & _
"e=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLED" & _
"B:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLED" & _
"B:Create System Database=False;Jet OLEDBon't Copy Locale on Compact=False;User" & _
" ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
|