471,355 Members | 1,626 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

Permission Denied

I am having an issue with a Microsoft Access 2003 database that has
forms designed to import data. When trying to do the import I get a
message microsoft office access permission denied. This is being done
on a Windows 2003 Server R2 SP1 Terminal Server. The interesting thing
is if I add the user to the domain admins group it work fine. I believe
their is a permission issue (duh), maybe on a file or folder, but
cannot pin point it.

I have verified that the user has access to the database and folder
that the database is in and SQL permissions are correct. Also, the same
user can do the import fine on another terminal server that is Windows
2003 Server SP1 (not R2).

Jan 12 '07 #1
3 8432
Is this a new install of Access on the terminal server? Check Microsoft for
compatibility issues. I know from experience Access97 on Windows 2000 TS had
special install requirements. I had a similar problem and came up with a
functional but work around. I only tried it after 2 weeks of email support
from Microsoft and I hand no other options. Create a group and assign it
"Read, Write, Modify, Execute" rights to the System32 directory, then assign
users to that group.

"jsamdirect" <su*****@jsamdirect.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...
I am having an issue with a Microsoft Access 2003 database that has
forms designed to import data. When trying to do the import I get a
message microsoft office access permission denied. This is being done
on a Windows 2003 Server R2 SP1 Terminal Server. The interesting thing
is if I add the user to the domain admins group it work fine. I believe
their is a permission issue (duh), maybe on a file or folder, but
cannot pin point it.

I have verified that the user has access to the database and folder
that the database is in and SQL permissions are correct. Also, the same
user can do the import fine on another terminal server that is Windows
2003 Server SP1 (not R2).

Jan 12 '07 #2
paii, Ron wrote:
Is this a new install of Access on the terminal server? Check Microsoft for
compatibility issues. I know from experience Access97 on Windows 2000 TS had
special install requirements. I had a similar problem and came up with a
functional but work around. I only tried it after 2 weeks of email support
from Microsoft and I hand no other options. Create a group and assign it
"Read, Write, Modify, Execute" rights to the System32 directory, then assign
users to that group.
Yes, it is a new install. I am not aware of any special install
requirements like there was with office and windows 2000 server ts. I
tried to assign permissions to the system32 directory for the user but
no change.

>
"jsamdirect" <su*****@jsamdirect.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...
I am having an issue with a Microsoft Access 2003 database that has
forms designed to import data. When trying to do the import I get a
message microsoft office access permission denied. This is being done
on a Windows 2003 Server R2 SP1 Terminal Server. The interesting thing
is if I add the user to the domain admins group it work fine. I believe
their is a permission issue (duh), maybe on a file or folder, but
cannot pin point it.

I have verified that the user has access to the database and folder
that the database is in and SQL permissions are correct. Also, the same
user can do the import fine on another terminal server that is Windows
2003 Server SP1 (not R2).
Jan 12 '07 #3

"jsamdirect" <su*****@jsamdirect.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
paii, Ron wrote:
Is this a new install of Access on the terminal server? Check Microsoft
for
compatibility issues. I know from experience Access97 on Windows 2000 TS
had
special install requirements. I had a similar problem and came up with a
functional but work around. I only tried it after 2 weeks of email
support
from Microsoft and I hand no other options. Create a group and assign it
"Read, Write, Modify, Execute" rights to the System32 directory, then
assign
users to that group.

Yes, it is a new install. I am not aware of any special install
requirements like there was with office and windows 2000 server ts. I
tried to assign permissions to the system32 directory for the user but
no change.

The "Fix" only worked if the permissions are assigned to a group and the
user is made a member of that group.

"jsamdirect" <su*****@jsamdirect.comwrote in message
news:11*********************@m58g2000cwm.googlegro ups.com...
I am having an issue with a Microsoft Access 2003 database that has
forms designed to import data. When trying to do the import I get a
message microsoft office access permission denied. This is being done
on a Windows 2003 Server R2 SP1 Terminal Server. The interesting thing
is if I add the user to the domain admins group it work fine. I
believe
their is a permission issue (duh), maybe on a file or folder, but
cannot pin point it.
>
I have verified that the user has access to the database and folder
that the database is in and SQL permissions are correct. Also, the
same
user can do the import fine on another terminal server that is Windows
2003 Server SP1 (not R2).
>

Jan 12 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jon Montana | last post: by
1 post views Thread by Mark E. Hamilton | last post: by
2 posts views Thread by Taishi | last post: by
reply views Thread by private.anders | last post: by
reply views Thread by private.anders | last post: by
4 posts views Thread by xzzy | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.