Batch file and Office 2003

[hockeylvr]

I've had a split Access 2000 database residing on our network server for a couple of years. I use a batch file opened by a hyperlink on our company intranet page which has been working great.

cd "c:\my documents" copy v:\Project\Materials\PurchSQE\Training\MaterialsTraining.mdb "c:\my documents\*.*"

"c:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "v:\Project\Materials\PurchSQE\Training\MaterialsTraining.mdb"

When they click on the "Training" link a window pops up asking them to either "Open" or "Save" the program. They choose "Open" and the database runs.

I have several people who have recently installed Office 2003 and now they are getting a window with the options "Run" or "Save" If they choose "Run" nothing happens, it all just closes. "Save" obviously saves the .bat file but that won't run for them either.

I have already taken care of the Securities issue that comes with 2003, but can't figure this one out.

I'm assuming this has to do with it trying to use Access 2003 to open an Access 2000 db, but don't know what to do to fix it. Does my batch file need to be changed? Will I need 2 different batch files to accommodate 2000 and 2003 users?

Thanks,

Toni

 

[PHV]

Replace this:
"c:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "v:\Project\Materials\PurchSQE\Training\MaterialsTraining.mdb"
By this:
start "v:\Project\Materials\PurchSQE\Training\MaterialsTraining.mdb"

Since officeXP the office directory has moved (Office10 for XP, Office11 for 2k3)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hockeylvr]

Thanks PH, I am getting this in the dos window now and the db does not open.

Microsoft Windows XP ....... usual version stuff.

C:\WINNT\Profiles\thart\Desktop>

Is there another piece I need?

Thanks!