"Server privleges for Access database

[Charlie]

The network specialist has asked me if users of the A2003 database (Terminal
Server and VPN) need "admin privileges". Do they?
TIA,
Charlie

 

[Arvin Meyer]

No. The permissions required for network shared folders are: Read, Write,
and Delete. The Delete permission is required to close the LDB file which
keeps track of locking. Without it all database usage become exclusive to 1
user.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

The one I forgot is Execute. Those are the Standard Permissions. The ones
you mention are called Special Permissions which are not usually necessary.
I always give them everything except Full Control because I am always
creating files in Excel, MapPoint, and PowerPoint with my code. In point of
fact, only an administrator needs to have Full Control, (what I believe was
the gist of the original question, anyway).

I think the question was asked because admins are now becoming aware of the
dangers of programs which require administrative privileges to run. If one
has admin privileges, one can modify the registry, install programs,
including malware, etc. So the direction today is to avoid programs which
require admin privileges to run. The network admin who probably only "heard"
that Access is not secure is trying to get a handle on protecting his
network. So the answer is, once again, NO one does not need admin
privileges. The users can (and should) be restricted as to what they can or
cannot do.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Omar Torres]

Arvin you're correct. I'm the network admin working with Charlie on this
project. I asked because I've seen Access databases that for some reason
(some control or something) they would not run unless the user had local
admin privileges on the machine. Since they will be running on TS I'm
planning on *only* allowing the users to run the Access database and
wanted to make sure they did not need local admin privs on the TS machine.

Thanks for your reply on the matter,

Omar Torres
Network Administrator
(remove underscores for email)

 

[Arvin Meyer]

Hi Omar,

I'm setting up an extensive TS installation right now. It seems like local
printers are the biggest issue. I must install the drivers on the Server and
add the local printer to each local connection.

One thing you need to remember when using TS. Each user needs to have
his/her own folder with the front-ends just like if they were operating from
a LAN. Here's the batch file I'm using to set each user up as they login:

@echo off
REM Check for existing user folder
if exist d:\users\%username% goto copynew

REM Create user folder
md d:\users\%username%

goto end

REM Copy latest database front ends.
:copynew
xcopy \\server\database\*.mdb d:\users\%username% /u /c /y /r

:end
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access