Bilbo_Baggins_Esq
Registered User.
- Local time
- Today, 05:45
- Joined
- Jul 5, 2007
- Messages
- 586
I have encountered a question from a customer, and am able to easily reproduce the issue, but cannot prove if the performance is by design (although I believe the performance is by design) because I cannot find it documented anywhere (either way).
Repro Steps:
1. link to a tab delimited text file in a new or existing Access 07 database
2. keep the linked table closed
3. open another database on the same box or over a network
4. link to the same text file in the second database
5. open the linked table in either database
6. Open the linked table in the other database
7 Error/Alert is issued
"The Microsoft Office Access database engine cannot open or write to the file "Text_Repro". It is already opened exclusively by another user, or you need permission to view and write its data."
It does not matter which database has the file open.
If one has it open, the other one will get the alert/error when trying to open the same linked table.
Of course, I know the file is read only in Access, but that is where this customer seemingly is trying to make his point. If it is read only, it should not matter how many times it is open.
He claims it was possible in Access 97, but has apparently been busted since Access 2000. I can find no support for this claim, nor do I understand why, now, in Access 2007 he should be surprised it is still not working.
I no longer have anything but Access 07 installed here at home.
I also fully understand the difference between busting and fixing is a question of perspective. If a feature is changed, and it is a feature you use/need, it is "busted". If you're a developer, and you know that feature is causing problems elsewhere and you change it, it is "fixed".
So I could use some little help here?
Can some members with Access 2003, 2002, 2000, and or 97 please try to
repro this with the above steps and let me know what you find out?
Does anybody else have any experience with linking to text files from multiple databases?
Does anybody happen to know if or where this functionality (or lack thereof) is documented in writing (i've not been able to locate anything specifically descriptive about multiple instances)?
Any help will be certainly appreciated!
Repro Steps:
1. link to a tab delimited text file in a new or existing Access 07 database
2. keep the linked table closed
3. open another database on the same box or over a network
4. link to the same text file in the second database
5. open the linked table in either database
6. Open the linked table in the other database
7 Error/Alert is issued
"The Microsoft Office Access database engine cannot open or write to the file "Text_Repro". It is already opened exclusively by another user, or you need permission to view and write its data."
It does not matter which database has the file open.
If one has it open, the other one will get the alert/error when trying to open the same linked table.
Of course, I know the file is read only in Access, but that is where this customer seemingly is trying to make his point. If it is read only, it should not matter how many times it is open.
He claims it was possible in Access 97, but has apparently been busted since Access 2000. I can find no support for this claim, nor do I understand why, now, in Access 2007 he should be surprised it is still not working.
I no longer have anything but Access 07 installed here at home.
I also fully understand the difference between busting and fixing is a question of perspective. If a feature is changed, and it is a feature you use/need, it is "busted". If you're a developer, and you know that feature is causing problems elsewhere and you change it, it is "fixed".
So I could use some little help here?
Can some members with Access 2003, 2002, 2000, and or 97 please try to
repro this with the above steps and let me know what you find out?
Does anybody else have any experience with linking to text files from multiple databases?
Does anybody happen to know if or where this functionality (or lack thereof) is documented in writing (i've not been able to locate anything specifically descriptive about multiple instances)?
Any help will be certainly appreciated!
