DB Not Unlocking?
I have a simple asp page that opens an mdb, reads it, updates 1 record, closes it. Here's the code:
View Replies
ADVERTISEMENT
Unlocking An Excel Worksheet In ASP
I have an excel sheet which is uploaded into the application. Since the workbook along with the sheets is locked with a password, while trying to insert the data to database, the record count is taking as null.
If I remove the lock manually and tried to insert, it is working perfectly. But I want to do the removal of lock programmatically. Do anybody knows how to remove the same with a password?