Run Access Database from Terminal Services

[cdw0308]

I am trying to run an access database from a terminal services server running Windows Server 2003.

I am trying to make the database startup immediately after logging into the server.
I have tried sever lines on the RDP connection file to start access and the database but nothing has worked.

program path and filename:
Start "C:\Program Files\Microsoft Office\Office12\msaccess.exe" "E:\EQUIP-DB\Shop Information.mdb"

Start in the following folder:
E:\EQUIP-DB

With this setting I get the following error after logging in.
"The System cannot find the specified file. The initial program cannot be started."

I have also tried this in the connection file.

Program path and filename:
"E:\EQUIP-DB\Shop Information.mdb"

Start in the following folder:
E:\EQUIP-DB

I the this error message after the above scripts.
An error (193) occured while creating user logon. The initial program cannot be started.

Any help with the startup script would be greatly appreciated.

Thanks

 

[markdmac]

Use a UNC path.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[cdw0308]

Can you elaborate on what you mean by UNC path?
The paths I have tried to use so far already are on my original post.

Thanks

 

[Roadki11]

\\servername\sharename\filename


RoadKi11

"This apparent fear reaction is typical, rather than try to solve technical problems technically, policy solutions are often chosen." - Fred Cohen

 

[cdw0308]

I have tried the UNC path as well and I still get this error message.

An error (193) occured while creating user logon. The initial program cannot be started.

Any other ideas?

 

[NortonES2]

Is the e:\ drive a local drive on the terminal server? If not ensure that it is correctly mapped before running Access

-------------------------------

If it doesn't leak oil it must be empty!!

 

[cdw0308]

I managed to figure it out.
I just wrote a batch script and called it to execute the access database at startup and it is working.

Thanks