Last post Mar 09, 2012 12:49 AM by Topspy
Mar 08, 2012 06:24 AM|santosh0683|LINK
i am doing Import data from EXCEL to SQL Database in ASP.NET.
its working fine on local system but when i deploy my application to production server it give below error.
"The Microsoft Office Access database engine cannot open or write to the file 'C:\Documents and Settings\santosh\Desktop\Book1.xlsx'. It is already opened exclusively by another user, or you need permission to view and write its data"
I expense total day to resolve this issue but not success.
Plz help it is very urgent.
Mar 08, 2012 06:34 AM|ramiramilu|LINK
it is a permissions issue, please give read/write permissions to IUSER account on that particular folder and on that file...also make sure tat file is not being used by any other process in the system...
I think that will solve your problem...
Mar 08, 2012 08:46 AM|HostingASPNet|LINK
You should give security permissions to the application pool user if you use
IIS 7 hosting.
Mar 09, 2012 12:49 AM|Topspy|LINK
Give "read and write" permission to "network service" user on the file, then reboot your computer. It would be working fine.