Access 2007 and windows 7

[OD]

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

 

[Matthew Thornton]

--
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.

 

[Allen Browne]

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"

 

[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

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

Reply to group, rather than allenbrowne at mvps dot org.

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

.

 

[Douglas J. Steele]

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

(no private e-mails, please)

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

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

Reply to group, rather than allenbrowne at mvps dot org.

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

.

 

[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

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

(no private e-mails, please)

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

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

Reply to group, rather than allenbrowne at mvps dot org.


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

.

.