Under windows xp and vista, I could use a command line switch with access,
but now I get an error.

EXAMPLE:

"c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact

[Now I get a message box saying that thier was a problem sending the command
to the program.]

Thanks
OD

--
Looking to make money at selling items on the web? Give us a try at
www.your-best-auctions.com. We are economical and cheaper then our
competitors. To unsubscribe, please reply with unsubscribe in the subject
line.


"OD" <(E-Mail Removed)> wrote in message
news:F2938FD5-BE50-4BA4-9792-(E-Mail Removed)...
> Under windows xp and vista, I could use a command line switch with access,
> but now I get an error.
>
> EXAMPLE:
>
> "c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
>
> [Now I get a message box saying that thier was a problem sending the
> command
> to the program.]
>
> Thanks
> OD

You forgot to include the full path to msaccess, e.g.:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /compact
"c:\Consulting Tracking Program\Consulting Tracking.accdb"

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"OD" <(E-Mail Removed)> wrote in message
news:F2938FD5-BE50-4BA4-9792-(E-Mail Removed)...
> Under windows xp and vista, I could use a command line switch with access,
> but now I get an error.
>
> EXAMPLE:
>
> "c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
>
> [Now I get a message box saying that thier was a problem sending the
> command
> to the program.]
>
> Thanks
> OD

It now seems to be working. Its funny that now I have to put the full path to
access to make it work, when before I only had to put the path to the
database and the switch. But any ways it works.

Thanks OD

"Allen Browne" wrote:

> You forgot to include the full path to msaccess, e.g.:
> "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /compact
> "c:\Consulting Tracking Program\Consulting Tracking.accdb"
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "OD" <(E-Mail Removed)> wrote in message
> news:F2938FD5-BE50-4BA4-9792-(E-Mail Removed)...
> > Under windows xp and vista, I could use a command line switch with access,
> > but now I get an error.
> >
> > EXAMPLE:
> >
> > "c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
> >
> > [Now I get a message box saying that thier was a problem sending the
> > command
> > to the program.]
> >
> > Thanks
> > OD
>
> .
>

I think you're mistaken. It's always been necessary to include the full path
to msaccess.exe: the switch is for the program, not for the database.

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


"OD" <(E-Mail Removed)> wrote in message
news:B647B866-0D4A-484E-B6C9-(E-Mail Removed)...
> It now seems to be working. Its funny that now I have to put the full path
> to
> access to make it work, when before I only had to put the path to the
> database and the switch. But any ways it works.
>
> Thanks OD
>
> "Allen Browne" wrote:
>
>> You forgot to include the full path to msaccess, e.g.:
>> "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /compact
>> "c:\Consulting Tracking Program\Consulting Tracking.accdb"
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>>
>> "OD" <(E-Mail Removed)> wrote in message
>> news:F2938FD5-BE50-4BA4-9792-(E-Mail Removed)...
>> > Under windows xp and vista, I could use a command line switch with
>> > access,
>> > but now I get an error.
>> >
>> > EXAMPLE:
>> >
>> > "c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
>> >
>> > [Now I get a message box saying that thier was a problem sending the
>> > command
>> > to the program.]
>> >
>> > Thanks
>> > OD
>>
>> .
>>

Yes it worked before, infact I checked to see if it was working on a clients
network, they are running xp. I use a batch file to compact the database
after hours.

thanks
OD

"Douglas J. Steele" wrote:

> I think you're mistaken. It's always been necessary to include the full path
> to msaccess.exe: the switch is for the program, not for the database.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "OD" <(E-Mail Removed)> wrote in message
> news:B647B866-0D4A-484E-B6C9-(E-Mail Removed)...
> > It now seems to be working. Its funny that now I have to put the full path
> > to
> > access to make it work, when before I only had to put the path to the
> > database and the switch. But any ways it works.
> >
> > Thanks OD
> >
> > "Allen Browne" wrote:
> >
> >> You forgot to include the full path to msaccess, e.g.:
> >> "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /compact
> >> "c:\Consulting Tracking Program\Consulting Tracking.accdb"
> >>
> >> --
> >> Allen Browne - Microsoft MVP. Perth, Western Australia
> >> Tips for Access users - http://allenbrowne.com/tips.html
> >> Reply to group, rather than allenbrowne at mvps dot org.
> >>
> >>
> >> "OD" <(E-Mail Removed)> wrote in message
> >> news:F2938FD5-BE50-4BA4-9792-(E-Mail Removed)...
> >> > Under windows xp and vista, I could use a command line switch with
> >> > access,
> >> > but now I get an error.
> >> >
> >> > EXAMPLE:
> >> >
> >> > "c:\Consulting Tracking Program\Consulting Tracking.accdb" /compact
> >> >
> >> > [Now I get a message box saying that thier was a problem sending the
> >> > command
> >> > to the program.]
> >> >
> >> > Thanks
> >> > OD
> >>
> >> .
> >>
>
>
> .
>