Access 2007 Runtime on Terminal Server

G

Guest

I am getting an error when running a Runtime application on Terminal Server.
If anyone other then myself opens the program they get the following message
- "Automatic Configuration of the current version of Microsoft Office Access
has failed. Your database might not function correctly. This can occur if
you do not have the necessary permissions to intall Microsoft Office Access
on this computer."
The server has Windows Server 2003 Service pack 1. It also has Office 2003
installed. We use Access 2003 and are trying to migrate to 2007. When I had
the runtime for 2007 installed it was taking the 2003 applications and trying
to open in 2007 runtime. Any suggestions?
 
6

'69 Camaro

Hi.
The server has Windows Server 2003 Service pack 1. It also has Office
2003
installed.
Click to expand...

Sorry. Only one version of Microsoft Office can run on Terminal Services.
Either get rid of Microsoft Office 2003 or get rid of the Access 2007
Runtime.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
P

Pieter Wijnen

Wrong!
The Problem is not TS related at all.
The problem is that all Access versions "compete" for the .mdb/.mde
extensions.
the extensions get "stolen" by whatever the last version to open a .mdb/.mde
The simplest solution is to always open them using the approperiate .exe &
shortcut
alternatively use custom extensions or assoiciate with a version checker
application
http://www.aylott.com.au/software.htm is one such

HTH

Pieter
 
6

'69 Camaro

Hi, Pieter.
Wrong!
The Problem is not TS related at all.
The problem is that all Access versions "compete" for the .mdb/.mde
extensions.
the extensions get "stolen" by whatever the last version to open a
.mdb/.mde
The simplest solution is to always open them using the approperiate .exe &
shortcut
Click to expand...

Go ahead and install two versions of Microsoft Office on Terminal Services
and use the shortcut trick when other users are doing the same thing with a
different version of Access at the same time. It won't work. Terminal
Services doesn't allow multiple users on the same computer to use different
versions of Microsoft Office at the same time.

The shortcut trick will work on a single workstation when multiple versions
of Microsoft Office are installed, because only one user is using the
multiple versions of Microsoft Office. It may also work with Remote Desktop
(I haven't tried it), but Terminal Services doesn't allow it.

Please see the following Web page for Microsoft's official stance on this:

http://support.microsoft.com/kb/928091

"Note Microsoft does not support using multiple versions
of Microsoft Office on versions of Microsoft Windows that
have Terminal Services enabled. If you want to run multiple
versions of Office, disable Terminal Services."

Since they probably need Terminal Services more than they need the extra
version of Microsoft Office, I recommended getting rid of the extra version
of Microsoft Office.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
R

Rick Brandt

'69 Camaro said:
Hi, Pieter.


Go ahead and install two versions of Microsoft Office on Terminal Services and
use the shortcut trick when other users are doing the same thing with a
different version of Access at the same time. It won't work. Terminal
Services doesn't allow multiple users on the same computer to use different
versions of Microsoft Office at the same time.

The shortcut trick will work on a single workstation when multiple versions of
Microsoft Office are installed, because only one user is using the multiple
versions of Microsoft Office. It may also work with Remote Desktop (I haven't
tried it), but Terminal Services doesn't allow it.

Please see the following Web page for Microsoft's official stance on this:

http://support.microsoft.com/kb/928091

"Note Microsoft does not support using multiple versions
of Microsoft Office on versions of Microsoft Windows that
have Terminal Services enabled. If you want to run multiple
versions of Office, disable Terminal Services."

Since they probably need Terminal Services more than they need the extra
version of Microsoft Office, I recommended getting rid of the extra version of
Microsoft Office.
Click to expand...

To be completely accurate though "does not support" is not the same as "does not
work".

Access 2007 might be different but I did have both 97 (runtime) and 2000 (full)
running on TS for several months and had no difficulties.
 
6

'69 Camaro

Hi, Rick.
To be completely accurate though "does not support" is not the same as
"does not work".
Click to expand...

"Does not work" as in Access 2007 gets error messages instead of running
smoothly. Since Microsoft assures us that they don't support multiple
versions of Office on Terminal Services, we can't complain when we do it
anyway. At least, not with a straight face.
Access 2007 might be different but I did have both 97 (runtime) and 2000
(full) running on TS for several months and had no difficulties.
Click to expand...

I can't speak for the older versions, but when Access 2007 is in the mix
with other versions on a Terminal Server, there are "difficulties."

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
R

Rick Brandt

'69 Camaro said:
Hi, Rick.


"Does not work" as in Access 2007 gets error messages instead of running
smoothly. Since Microsoft assures us that they don't support multiple
versions of Office on Terminal Services, we can't complain when we do it
anyway. At least, not with a straight face.


I can't speak for the older versions, but when Access 2007 is in the mix with
other versions on a Terminal Server, there are "difficulties."
Click to expand...

Well, I certainly can't argue with that. Often that is true on plain old single
user PCs as well '-)
 
G

Guest

Can I just uninstall Access 2003 or do I have to uninstall all of Office
2003? I did not want to upgrade to Office 2007 because of the licensing
cost. I just want to use the Access Runtime 2007
 
6

'69 Camaro

Hi.
Can I just uninstall Access 2003 or do I have to uninstall all of Office
2003? I did not want to upgrade to Office 2007 because of the licensing
cost. I just want to use the Access Runtime 2007
Click to expand...

Discussions with Microsoft employees indicate it's the "whole pie," not just
certain slices that must be removed so that multiple versions of Office
aren't running on the Terminal Server at the same time. But it wouldn't
hurt to try uninstalling Access 2003 to find out if that's enough.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
T

Tony Toews [MVP]

alternatively use custom extensions or assoiciate with a version checker
application
http://www.aylott.com.au/software.htm is one such
Click to expand...

Regretfully he hasn't updated his utility to work with A2007 yet.

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's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Terminal Server - Access 2003 & 2007 2
Access Runtime on a Windows 2008 Terminal Server 0
Access 2007 runtime and Terminal Services 2
Access 2003 --- Access 2007 Runtime Conflict 8
Access 97 Installed with 2007 Runtime 3
Problems with Access runtime 2
Access 2007 Runtime 1
Access 2003 RT on Server 2008 R2 64bit 0

Top