Re: Unable to access folder from A2003

What is the command line that your launcher program uses to open Access and
the database once it is assured that you have the current front-end? Is
Access on all computers set to open in Shared mode as a default
(Tools|Options|Advanced tab)? Are there any restrictions on the shared
folder limiting the number of users? Do the front-end, back-end, or
workgroup (mdw) file have the same first part of their name (i.e.
MyDatabase.mdw, MyDatabase.mdb)?

--
Wayne Morgan
MS Access MVP


"rdemyan via AccessMonster.com" <u6836@uwe> wrote in message
news:60a244275175c@xxxxxx
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

  • Unable to access folder from A2003
    ... I'm having trouble accessing files in a folder on another ... I have a launcher program that launces my application (MyApp). ... using Windows Explorer and copying the files into it. ...
    (comp.databases.ms-access)
  • Re: Microsoft Common Dialog control, version 6.0
    ... Did you try it with a folder on the C: ... Kevin E. wrote: ... "Tom Ogilvy" wrote: ... Microsoft Excel opens the file dialog allowing the user to ...
    (microsoft.public.excel.programming)
  • Re: Now in 2003, No code is highlighted..
    ... No dialogue box opens. ... What I want it to do is open all the files in the folder and save as the ... Dim FirstLoop As Boolean ...
    (microsoft.public.word.vba.general)
  • Re: Image Viewing Software for CDs
    ... Download the file Slideshow.exe in one of your folder, ... this window to copy to a CD-R. ... Check if your drive is set for recording. ... but you can't find a Recording tab when the window opens. ...
    (microsoft.public.windowsxp.photos)
  • Now in 2003, No code is highlighted..
    ... No dialogue box opens. ... What I want it to do is open all the files in the folder and save as the ... Dim FirstLoop As Boolean ...
    (microsoft.public.word.vba.general)