Starting Access 2007 App on Windows 2003 Terminal Server

[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 so the user cannot gain access to the desktop of 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

 

[lameid]

I would do 2 things.

First, make a short cut that works that opens the file from the desktop.

Second post the working target and issue in the windows forum...

forum931


You might get lucky here yet it is really a server issue.

If you wouldn't mind, link the thread here so that everyone can see the result.

Also I have to add, that you should have proper security for the user session and not rely on Access being maximized to protect your server.

 

[jrbarnett]

Does Access itself work? ie can you open it, open the DB and it will work with the same logon as you will need.
If it works as an administrator but not as a normal user then its almost certainly down to file system permissions somewhere.

John

 

[Christineeve]

I don't know if you've read this information. You're probably way ahead of the game on this, but I'm looking to move our apps to terminal services and I used this as a starting reference:

http://msdn.microsoft.com/en-us/library/ms811523.aspx

 

[edgcardoso]

Hello guys
I already have this issue and i just can solve that.
Try to create one batch file, calling the application you will need , for example

"
@Echo off

call E:\EQUIP-DB\Shop Information.mdb

exit
"

after on terminal Server Configuration manager , add the following:

program path and filename:
Start "C:\"name of batch file.bat"


This will solve the error 193

Cheers

Edgar cardoso

 

[edgcardoso]

On my last reply i give us one solution, but there is one problem when you try to open more than one Terminal Server session, give us the error that application is in use with other person or process.

This error is caused by dos command "call"

To solve this issue and this is the right configuration, you must put the following entrie on start up program on Group Policy

C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE "C:\BD_STECNICOS\database_name.mdb"

The first line, put the entire path to application that will open the program, following the entire path to file to be open

Cheers