Unable to access folder from A2003



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
.



Relevant Pages

  • Re: Unable to access folder from A2003
    ... Not sure why the command line to launch MyApp (located in a folder on ... what to connect to and where the workgroup file is (I need the workgroup ...
    (comp.databases.ms-access)
  • Re: Unable to access folder from A2003
    ... Not sure why the command line to launch MyApp (located in a folder on the ... When I launch MyApp, I pass in some information including the location of the ... the workgroup file and some boolean variables that tell MyApp ...
    (comp.databases.ms-access)
  • Re: Unable to access folder from A2003
    ... 'Update' folder. ... I have a launcher program that launces my application (MyApp). ... launcher program opens it with a DAO recordset and gets the version ...
    (comp.databases.ms-access)
  • RE: "Unable to remove the directory C:Documents and Settings..."
    ... I find that there exists a folder 'myApp' but in ...
    (microsoft.public.windows.terminal_services)
  • Re: recover compacted folders
    ... Because of this tendency of attachments to infect, ... , then wasted space is generated in that file, and the folder must be ... Windows 2000 and Windows XP. ... Windows XP Service Pack 2 Resources for IT Professionals ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)