I have two applications, each with its own workgroup file. The older
application starts with a shortcut and there is no problem. The newer
application I have to use a batch file to start because I have to copy some
files into the local directory each time. This means that I can't use a
shortcut to start the application. I tried putting the path to the mdw on
the command line, but access seems to ignore it. Can this be done? If so,
can anyone tell me what I am doing wrong? Here is the command line from the
batch file:

START "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\MSACCESS.EXE"
"%userprofile%\my documents\accounting system\v2_purch_fe_2002.mde"
/wrkgrp"\\townhall\purchase requisitions\system.mdw"

What's happening? Are you getting an error?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"SandyR" <(E-Mail Removed)> wrote in message
news:27AD7A53-7544-40BC-9F47-(E-Mail Removed)...
>I have two applications, each with its own workgroup file. The older
> application starts with a shortcut and there is no problem. The newer
> application I have to use a batch file to start because I have to copy
> some
> files into the local directory each time. This means that I can't use a
> shortcut to start the application. I tried putting the path to the mdw on
> the command line, but access seems to ignore it. Can this be done? If
> so,
> can anyone tell me what I am doing wrong? Here is the command line from
> the
> batch file:
>
> START "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\MSACCESS.EXE"
> "%userprofile%\my documents\accounting system\v2_purch_fe_2002.mde"
> /wrkgrp"\\townhall\purchase requisitions\system.mdw"
>

I don't get an error - it just doesn't change me to the workgroup specified.

"Douglas J. Steele" wrote:

> What's happening? Are you getting an error?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "SandyR" <(E-Mail Removed)> wrote in message
> news:27AD7A53-7544-40BC-9F47-(E-Mail Removed)...
> >I have two applications, each with its own workgroup file. The older
> > application starts with a shortcut and there is no problem. The newer
> > application I have to use a batch file to start because I have to copy
> > some
> > files into the local directory each time. This means that I can't use a
> > shortcut to start the application. I tried putting the path to the mdw on
> > the command line, but access seems to ignore it. Can this be done? If
> > so,
> > can anyone tell me what I am doing wrong? Here is the command line from
> > the
> > batch file:
> >
> > START "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\MSACCESS.EXE"
> > "%userprofile%\my documents\accounting system\v2_purch_fe_2002.mde"
> > /wrkgrp"\\townhall\purchase requisitions\system.mdw"
> >
>
>
>

I take back my previous statement - the error I get is the one telling me
that I don't have a right to access the data base (because it is looking at
the wrong mdw)

"Douglas J. Steele" wrote:

> What's happening? Are you getting an error?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "SandyR" <(E-Mail Removed)> wrote in message
> news:27AD7A53-7544-40BC-9F47-(E-Mail Removed)...
> >I have two applications, each with its own workgroup file. The older
> > application starts with a shortcut and there is no problem. The newer
> > application I have to use a batch file to start because I have to copy
> > some
> > files into the local directory each time. This means that I can't use a
> > shortcut to start the application. I tried putting the path to the mdw on
> > the command line, but access seems to ignore it. Can this be done? If
> > so,
> > can anyone tell me what I am doing wrong? Here is the command line from
> > the
> > batch file:
> >
> > START "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\MSACCESS.EXE"
> > "%userprofile%\my documents\accounting system\v2_purch_fe_2002.mde"
> > /wrkgrp"\\townhall\purchase requisitions\system.mdw"
> >
>
>
>

Are you getting prompted for user credentials?

Are you sure you're using the correct MDW?

Have you tried opening the file using a shortcut, just to ensure that the
security was set up properly?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"SandyR" <(E-Mail Removed)> wrote in message
news:4FB8E72B-B280-4C02-8429-(E-Mail Removed)...
>I take back my previous statement - the error I get is the one telling me
> that I don't have a right to access the data base (because it is looking
> at
> the wrong mdw)
>
> "Douglas J. Steele" wrote:
>
>> What's happening? Are you getting an error?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "SandyR" <(E-Mail Removed)> wrote in message
>> news:27AD7A53-7544-40BC-9F47-(E-Mail Removed)...
>> >I have two applications, each with its own workgroup file. The older
>> > application starts with a shortcut and there is no problem. The newer
>> > application I have to use a batch file to start because I have to copy
>> > some
>> > files into the local directory each time. This means that I can't use
>> > a
>> > shortcut to start the application. I tried putting the path to the mdw
>> > on
>> > the command line, but access seems to ignore it. Can this be done? If
>> > so,
>> > can anyone tell me what I am doing wrong? Here is the command line
>> > from
>> > the
>> > batch file:
>> >
>> > START "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\MSACCESS.EXE"
>> > "%userprofile%\my documents\accounting system\v2_purch_fe_2002.mde"
>> > /wrkgrp"\\townhall\purchase requisitions\system.mdw"
>> >
>>
>>
>>

Thank you - I didn't think of trying the shortcut - it doesn't work either.
I guess I need to get it to work and then use the same path in my batch file.
"Douglas J. Steele" wrote:

> Are you getting prompted for user credentials?
>
> Are you sure you're using the correct MDW?
>
> Have you tried opening the file using a shortcut, just to ensure that the
> security was set up properly?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "SandyR" <(E-Mail Removed)> wrote in message
> news:4FB8E72B-B280-4C02-8429-(E-Mail Removed)...
> >I take back my previous statement - the error I get is the one telling me
> > that I don't have a right to access the data base (because it is looking
> > at
> > the wrong mdw)
> >
> > "Douglas J. Steele" wrote:
> >
> >> What's happening? Are you getting an error?
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >> "SandyR" <(E-Mail Removed)> wrote in message
> >> news:27AD7A53-7544-40BC-9F47-(E-Mail Removed)...
> >> >I have two applications, each with its own workgroup file. The older
> >> > application starts with a shortcut and there is no problem. The newer
> >> > application I have to use a batch file to start because I have to copy
> >> > some
> >> > files into the local directory each time. This means that I can't use
> >> > a
> >> > shortcut to start the application. I tried putting the path to the mdw
> >> > on
> >> > the command line, but access seems to ignore it. Can this be done? If
> >> > so,
> >> > can anyone tell me what I am doing wrong? Here is the command line
> >> > from
> >> > the
> >> > batch file:
> >> >
> >> > START "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\MSACCESS.EXE"
> >> > "%userprofile%\my documents\accounting system\v2_purch_fe_2002.mde"
> >> > /wrkgrp"\\townhall\purchase requisitions\system.mdw"
> >> >
> >>
> >>
> >>
>
>
>