Excel and Access user permissions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davidp - 23 Nov 2005 19:56 GMT

If i'm importing and exporting excel from access, I can do this until the
cows comes home. Where I have the probem is I need to either pull or update
a particular cell in a table or have the ability to format the cell.

From what I found (trial & error) is that the user must have power or admin
user rights on the local pc.

Is this correct? If it isn't, what kind of permissions needed to be set for
the user. Some of my customers have the users very restricted on the network
and on the local pc. Some customers will not grant the user anything above
basic level.

Reply to this Message

Douglas J. Steele - 23 Nov 2005 22:28 GMT

I've never found this to be the case. I've written numerous applications
that automate Excel from Access, generating charts and the like with my
users not having any special permissions. (mostly Office 97 on NT4, SP6, but
also some Office 2003 on XP)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> If i'm importing and exporting excel from access, I can do this until the
> cows comes home. Where I have the probem is I need to either pull or
[quoted text clipped - 12 lines]
> above
> basic level.

Reply to this Message

RobFMS - 26 Nov 2005 00:21 GMT

I, too, have done a lot with Excel Automation and I have not had any issues
with permissions.
If your users are being restricted, determine what those restrictions may
be. Are they restricted to a certain network drive? Are they restricted by
only have Read-Only permissions to a particlar drive/path? If this is the
case, determine if there is a drive/path that is Read/Write permission-able
for the user to use and see if the same problem occurs.

HTH

Rob Mastrostefano

Signature

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

Reply to this Message

davidp - 28 Nov 2005 21:30 GMT

The users have read/write/change permission on the local C (most of them).
As for network permissions, this is all over the place. One that I wish to
avoid by limiting to just C drive.

Just from my playing around (in the past) as basic user, I couldn't modify
the content or the format a specific cell or delete/append a range. But
under poweruser or admin level, I could.

What kind of permissions would he basic user need? This was done on Win 2k
and office 2K machine. Haven't tried it on XP yet.

Reply to this Message