fayeinspain
Technical User
I have a data access page that reads a MS Access database. This works fine when the mdb file is on my c: drive, but when I put it on the webserver I get an error message: Microsoft Office Web Components could not open the database "\\website\test\fpdb\database.mdb".
My connection string now is:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\website\test\fpdb\database.mdb;Mode=Share Deny None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB
atabase Password=&quot;&quot;;Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&quot;&quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>
Thank you for any help!
David & Faye
My connection string now is:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\website\test\fpdb\database.mdb;Mode=Share Deny None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB
atabase Password=&quot;&quot;;Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&quot;&quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>Thank you for any help!
David & Faye