Unable to run multiple connections to a database through terminal server.

[Roget Luo]

This situation is quite strange, we have 2 terminal servers (named:
terminal1 and terminal2) w/ the exact same configuration. Both connected to
a file server and allows users to access a MS Access database (let's call it
data1). On terminal1, everything runs like it suppose to, allows multiple
user access at the same time. However, I'm running into the following
problems on terminal2.

1. When user first double click on the shortcut to data1, they get the
"Open File - Security Warning" pop up asking "Do you want to open this
file?" and list the following info:
Name: data1
Publisher: Unknow Publisher
Type: MS Office Access Applicants
From: file path
***How can I get rid of this?

2. If someone has data1 opened already from ANYWHERE (terminal1, terminal2
or thru local client computer), it will not let anyone else open it from
terminal2. Any idea why?

Thanks in advance.

Roget

 

[Van T. Dinh]

Possible problems:

1. The Access installation on the terminal2 has Macro Security set to
Medium (likely) or High.

Check the Menu Tools / Macro / Security and see whether the 2 Access
installations have the same setting for this.

Also check and make sure that both terminal servers and Access instllations
are fully patched.

2. It sounds like terminal2 tries to open the file in exclusive mode. Try
opening Access first and then open the file in *shared* mode.

 

[Roget Luo]

Thanks for the suggestions, Van.
1. I used group policy from the server to set the security to low and it's
applied to both Termina01 and 02. I check the setting under Macro and it's
set to low. Also, both terminal servers are running Access 2003 and are
fully patched.
2. Is there a way to set open in shared mode globally, since there are 20
or so users accessing terminal02, and it's impossible to get each of them to
open Access first then open the file in shared mode.

Thanks again,
Roget

 

[Van T. Dinh]

I am not too good on the server side but you probably can use the group
policy to set the "Default Open Mode" to Shared rather than Exclusive.

The equivalent setting through the Access GUI is the Menu Tools / Options /
Advanced tab.

Alternatively, I guess you can create a desktop shortcut icon (for all
users) that has appropriate Startup command-line options to open the
database in shared mode. Check Access Help topic "Set command-line options
for starting Access".

OTOH, in my set-up (Access Front-End on Windows 2003 Terminal Server with
Microsoft SQL Server Back-End), each user has a separate Front-End rather
than all users sharing the same MDB file. There are possible complications
with sharing the same MDB file, either as a single MDB file application or a
Front-End only, mainly corruptions.