- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I create an OLEDB data connection with Excel file on Designer ES2, my form will only need to read this file for data, there is no need to lock it at all.
Following is my connection string :
Provider=MSDASQL.1;Persist Security Info=False;Data Source=Excel Files;Mode=Read;Extended Properties="DSN=Excel Files;DBQ=C:\test.xls;DefaultDir=C:;DriverId=790;MaxBufferSize=2048;PageTimeout=5;"
The case is after I open my pdf, then if I open the excel file using Office Excel, it will prompt a dialog which told it is being used by some application now, either choose Read only or ....
In fact I just need to read the Excel file for data in my pdf, I hope I can still edit the excel file in office at the same time.
So I change the mode from Read to Share Deny None, as shown below:
Provider=MSDASQL.1;Persist Security Info=False;Data Source=Excel Files;"Mode=Share Deny None";Extended Properties="DSN=Excel Files;DBQ=C:\test.xls;DefaultDir=C:;DriverId=790;MaxBufferSize=2048;PageTimeout=5;"
However now I can't even open the excel file in Office after I open my form, it simply tells can't use the file at all.
Any ideas?
Views
Replies
Total Likes