I have a batch file running on a client PC with a single line which looks like this (server name etc changed for security reasons)
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "\\mySserver\myDirectory\myDatabase.mdb" /cmd "myParameter"
When I run the file on the client PC by double clicking it, it runs perfectly fine and opens the database with the parameter. When I run the file from myServer over the network it opens access and I get an error message which reads 'Microsoft Access can't find the database \\mySserver\myDirectory\myDatabase.mdb'
I don't understand why the same batch file will run correctly locally but not when run over the server. I've tried putting echo hello just to test the batch file is running properly and it is fine.
So is this a problem with access? Should I write the path differently? I've tried using the same system to run a local database file and hit exactly the same issue.
Please help! I'm tearing my brain out through my eye sockets on this one!
Thank you :)