Unable to access folder from A2003
- From: "rdemyan via AccessMonster.com" <u6836@uwe>
- Date: Mon, 22 May 2006 14:14:31 GMT
With A2003, I'm having trouble accessing files in a folder on another
computer where back-end files, update files, etc are located. Here's the
scenario:
1) Computer #1 - A2003
2) Computer #2 - Access 2000; folder with back-ends for both computers and
'Update' folder.
I have a launcher program that launces my application (MyApp). The launcher
program also checks for updates to MyApp located in 'Update' folder (on
Computer #2). If there is an update file in the 'Update' folder, the
launcher program opens it with a DAO recordset and gets the version number.
If the version number of MyApp in the 'Update' folder is higher than the
version number of MyApp on Computer #1, then MyApp in the 'Update' folder is
downloaded and replaces MyApp on Computer #1.
All of this code works fine. The problem is that on Computer #1 (A2003),
I've been having problems accessing MyApp in the 'Update' folder. I keep
getting a message that 'MyApp' in the 'Update' folder is already opened
exclusively. I am 100% sure that it is not open and there is no .ldb file.
HOWEVER, if I create a new folder ('NewFolder') on Computer #2, where the
Update folder is located, then copy MyApp in the 'Update' folder to
'NewFolder', and then reset the location on the launching program on Computer
#1 to 'NewFolder' (where the launching program searches for updates),
everything works fine. No more exclusivity errors.
I've seen this before. It's like files in the folder on Computer #2 somehow
can now longer be accessed by A2003 (I never have this problem with A2K).
Now I can solve the problem simply by creating a new folder on Computer #2
using Windows Explorer and copying the files into it. Then I can delete the
old folder and rename the new folder with the old folder name. But clients
aren't going to want to do this.
What is causing this problem??? I'm not doing anything with Windows folders
permissions. Both computers run Windows XP home editions.
Thank you for any ideas, suggestions,etc.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200605/1
.
- Follow-Ups:
- Re: Unable to access folder from A2003
- From: Wayne Morgan
- Re: Unable to access folder from A2003
- Prev by Date: Re: Dcount and SQL expression
- Next by Date: Import delimited file won't import space value
- Previous by thread: List query
- Next by thread: Re: Unable to access folder from A2003
- Index(es):
Relevant Pages
|