Re: Unable to access folder from A2003

Ok, just to clarify, are you having problems copying the updated file or
opening your app once you've made sure that you have the most current file?

The command line will make a difference, especially if it has the /excl
switch on it. This opens the file exclusively. Where you looks in the
Options isn't what I was referring to. I was referring to the command line
used to open your app. It would be something like:

"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /wrkrgp
"<path>\MyWorkgroup.mdw" /user UserName /pwd Password

What happens if you open the app without using the updater first, do the
problems go away? I suspect that the updater is locking the file for some
reason.

--
Wayne Morgan
MS Access MVP


"rdemyan via AccessMonster.com" <u6836@uwe> wrote in message
news:60a30d52ce523@xxxxxx
Thanks for the response:

1) Not sure why the command line to launch MyApp (located in a folder on
the
local computer) is an issue. The launcher has not had problems launching
the
MyApp program. It's the opening of MyApp update file on the peer computer
that is the issue. Keep getting exclusivity problems.

HOWEVER: I looked at the command-line arguments shown in the
(Tools|Options|Advanced tab) between A2000 and A2003. THEY ARE DIFFERENT.
When I launch MyApp, I pass in some information including the location of
the
back-end files, the workgroup file and some boolean variables that tell
MyApp
what to connect to and where the workgroup file is (I need the workgroup
file
because MyApp also can launch other workgroup protected files.
A2003,however,
only shows the workgroup file in the Command-line argument!!??

One other difference is the DDE operations. A2003 has 'Enable DDE
Refresh'
while A2K has nothing checked.

BUT, the problem I'm having is within the launching program not MyApp once
it
opens.

2) Yes Access on all computers is set to open in Shared mode.

3) To be honest, I don't even know how to set restrictions on shared
folders
in Windows XP Home Edition. Windows Explorer on any of the peer computers
can see the 'Update' folder (and files within) located on Computer #2.
There's only one user right now, so I'm not sure that would be the issue.

4) All files have different names.

All I did to eventually get this to work was create a new folder on
Computer
#2 (which is acting as the server) and copy the files located in the
'Update'
folder (which is giving me the problems) to the NewFolder. Then I change
the
folder location on the launcher on Computer #1 to NewFolder from Update
and
everything works fine!!??

Could this be an A2003 problem. A2000 has never exhibited this problem.

Wayne Morgan wrote:
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)?

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
[quoted text clipped - 44 lines]

Thank you for any ideas, suggestions,etc.

--
Message posted via http://www.accessmonster.com


.

Relevant Pages

  • 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: Problems reinstalling Office 2004 G4 PowerPC
    ... Reinstalling rarely fixes issues like you mentioned. ... Combo updaters will install on the same ... Backup your Documents folder. ... launch Word or any other Office app all I got was a flash of the name on the ...
    (microsoft.public.mac.office)
  • Re: Found it - Lost my quick launch
    ... Since the copied folder structure was incomplete, ... >>> What were the local admin tasks??? ... >>> admin login, just not for mine, it would seem to me that it would be an ... >>>> Quick Launch: Gives error message, ...
    (microsoft.public.windowsxp.general)
  • Re: Multiple instances of the QuickLaunch toolbar being loaded
    ... quick launch bar to be shown on the taskbar. ... The quick launch tool bar is a folder in the Documents and Settings portion ... If there are not multiple copies, is the path the same for all of ...
    (microsoft.public.backoffice.smallbiz2000)
  • 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)