Using MS Access Through Terminal Server

[Randy]

I develop in a MS Access Front End to a SQL Server Database. We deploy
our program to different Organizations, most of which use it on a LAN.
Recently, as we have expanded to new customers, some of them have remote
users using th program through a Terminal Service session. I have them
all locked down so that all they can do is run the program, but in order
to allow them to run Access through Terminal Services it tells me that
they need Admin Rights, so I essentially end up making them
administrators. They can't do anything because they are only allowed to
run Access, but I would rather not have 15 administrators running around
a company, but I can't figure out any other way to get it done then this.

Any ideas?

 

[Joe Fallon]

Check out Tony's site - he has a section on Terminal Server and Access.

http://www.granite.ab.ca/access

 

[Tony Toews]

Check out Tony's site - he has a section on Terminal Server and Access.
http://www.granite.ab.ca/access

Yeah, but I don't have anything on the admin problem he mentions.
Although possibly one of the links to an MS article may be of
assistance.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

I develop in a MS Access Front End to a SQL Server Database. We deploy
our program to different Organizations, most of which use it on a LAN.
Recently, as we have expanded to new customers, some of them have remote
users using th program through a Terminal Service session. I have them
all locked down so that all they can do is run the program, but in order
to allow them to run Access through Terminal Services it tells me that
they need Admin Rights, so I essentially end up making them
administrators.

So what version of Access and Windows? What's the exact error
message?

They can't do anything because they are only allowed to
run Access, but I would rather not have 15 administrators running around
a company, but I can't figure out any other way to get it done then this.

I'd agree with your distaste for this approach. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm