Hi

When i attach data source through local address it working properly
data source="c:\db1.mdb"

But when use Local host path using Server.Mappath("") then i receive error cannot open database engine. File open in exclusive mode or it open by another user .

If any one have solution reply me

Best Regards
Anees Shoukat

hi,

it will be help ful if you provide the code

Anubhav Kumar

It may be possible that u have placed that database outside
webFolder and then do not have permission.
Can u give me the detailed code and also location of your folders.


rajkumar sharma

WEB PAth
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source="+Server.MapPath("/bragcs/")+"mail.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=Share Deny None;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";

Local Path
//this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=""c:\mail.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=Share Deny None;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";

I Put data base file on bragcs folder

hello anees ,
Put your bragcs database in the WebFolder(where your
application files are placed) and then run it .
It may work then.
and also remove the first slash means(instead of /bragcs/
write bragcs/



rajkumar sharma

ok i try it

I have just faced similar problem, but the database is corrupt, actually. I create a new, empty database. Go to File menu-> Get External Data-> Import. Now you can import every valid table. This will give me a clean set of systems tables. Sometimes this still not help, I would like to use a tool called Advanced Access Repair to repair many corrupt Access mdb files. But this is the last choice.

fyz