open access db from read only media (eg. CD)
i kinda need a way to open and read only an access db into a dataset in C#. the connection string i'm using is:
"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""support/db.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Read;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
the app is working fine when i use a read-only directory, dut when it comes to CD it fails... don't know why?
note that with this way (read-only dir AND Mode=read) the lock file access create, does not exist nor is attempted to be created (think so...)
please help.
|