Security and slow performance on linked tables

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Here is my current config: I have a code database and a
data database. I am using linked tables to access the
data database on the network. I use a global variable to
hold the database connection open on a single table so
that I get better performance on the data database. I set
up security on the code and data database. Every user in
the company can access the data database with good speed
except the users with Admins authority. Any clue as to
why the admin user would get slow performance and other
users do not. The mdw file has been downloaded to each
user's machine and links to this workgroup file. Before
security was set up, the Admins users were just fine. It
takes at least a full minute or two just to open a linked
table. Before security was configured, it took less than
half a second. What am I missing?
 
Security-wise, I can't see what you might be missing. Is there anything
peculiar about the machines that the "admin" users are opening the database
from? Has anythhing changed on those users' setups?
 
Thanks Lynn. I did discover the problem. I am linking to two backend
databases. One of them is for data and the other contains security
information. The security database is located in a 'read only' folder. Two
users have 'Full Contol' over these folders. Evidently, this mixture of
permission settings was causing an enormous lag as the 'windows' operating
system read the permissions on the folder. In the directory where the data
is located, the speed is fine once a database connection is cached using a
global recordset. To test our theory, we changed the windows permission
settings on the 'security' folder to read only for one of the administrator
accounts. The speed issue disappeared. MS Access must not like it when
there are multiple windows permission settings on a single folder based on
users. It appears it is an all or nothing affair. If everyone has 'full
control' it runs fine. If everyone has read only, it runs fine. Somewhere
in-between, not so fine.

Thanks for replying.
Adam
 
Back
Top