By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Permission Denied

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a

"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.