Hello everyone, I come to ask for your help by a problem that has me crazy.
I have an application in Ms-Access (used by several users) that obtains information from an excel file through ADODB and is displayed on a form. The excel file is only updated by a person via Ms-Excel. The problem that I have is, if at that time the excel file is open (it is being updated or is simply open), and from my app in Ms-Access we want to get information, two things happen:
1-In my Ms-Access app an error appears (Run time error -2147467259 (80004005)) saying that the excel file can not be opened because it is being used by another user.
OR
2-The information is displayed correctly in the Ms-Access form, but at the same time the Ms-Excel file is opened in read-only mode. Which is very annoying to be closing every time this file in read only mode.
How to avoid these types of problems, there will be some way to avoid this using other way to open a Ms-Excel file?
Thanks for your help.
Attached code using ADOBD.
I have an application in Ms-Access (used by several users) that obtains information from an excel file through ADODB and is displayed on a form. The excel file is only updated by a person via Ms-Excel. The problem that I have is, if at that time the excel file is open (it is being updated or is simply open), and from my app in Ms-Access we want to get information, two things happen:
1-In my Ms-Access app an error appears (Run time error -2147467259 (80004005)) saying that the excel file can not be opened because it is being used by another user.
OR
2-The information is displayed correctly in the Ms-Access form, but at the same time the Ms-Excel file is opened in read-only mode. Which is very annoying to be closing every time this file in read only mode.
How to avoid these types of problems, there will be some way to avoid this using other way to open a Ms-Excel file?
Thanks for your help.
Attached code using ADOBD.
Attachments
Last edited: