Access Security Problems On XP

[C]

Hello. I have released an MS Access 2002 application that
consists of two MDE databases. I have "secured" the
application by following the procedure of using a
different workgroup info file to develop a user that is
the owner of the database and removing admins group
privileges from the Admin user while setting up the Admin
user to be a part of the normal Users group. The
application is released without the workgroup info file
and the users are accessing the form from a shortcut that
does not use a userid/password. The Users group has all
the privs that are needed for the application to
function. It appears that the application runs correctly
on every PC that is not an XP operating system. The XP
systems give the user the error "You do not have the
necessary permission to use" against one of the tables.
The table is the first one that is being opened by the
application but (whether this is related to the problem or
not, I don't know) it is an attached table from the second
mde file (not the one that the application initially
opens). I am perplexed, especially since I (and others)
have used the application without any problems on a number
of different machines that were not XP based. By the way,
in most cases the Access 2002 runtime is being installed
as part of the application installation. Thanks for your
help!!

 

[ED]

You can check if the user has Modify Design permission to the object;



It seems your database is using Access User level security. Check the
security for the local machine is pointing to a correct one.

 

[C]

Thanks again for the response. According to what I have
read in the various tech blurbs, I should not need to (and
should not) release the MDW file since the client's
Default MDW file with the Admin user will have the rights
that they need to use the application. I am still
perplexed why this application works fine on non-XP
machines and would welcome some information on why this is
happening in XP environments.
P.S. I was hoping that I would get an MS response within
the advertised window of time for this managed newsgroup
and would also like to know what I have done to not
receive the response. Is this normal?

 

[Alick [MSFT]]

Hi,

We may need to double check the default mdw file on the clients; make sure
it uses admin account by default instead of other accounts. In other words,
on the client they did not change/customize any security account.

In addition, we can check if you take away permissions on the
MSysAccessObjects table in the database? If so, that can cause the issue;

Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



--------------------
| Content-Class: urn:content-classes:message
| From: "C" <[email protected]>
| Sender: "C" <[email protected]>
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:2129
| NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.security
|
| Thanks again for the response. According to what I have
| read in the various tech blurbs, I should not need to (and
| should not) release the MDW file since the client's
| Default MDW file with the Admin user will have the rights
| that they need to use the application. I am still
| perplexed why this application works fine on non-XP
| machines and would welcome some information on why this is
| happening in XP environments.
| P.S. I was hoping that I would get an MS response within
| the advertised window of time for this managed newsgroup
| and would also like to know what I have done to not
| receive the response. Is this normal?
|
|

 

[mig2000]

Originally posted by C

Hello. I have released an MS Access 2002 application that

consists of two MDE databases. I have "secured" the

application by following the procedure of using a

different workgroup info file to develop a user that is

the owner of the database and removing admins group

privileges from the Admin user while setting up the Admin

user to be a part of the normal Users group. The

application is released without the workgroup info file

and the users are accessing the form from a shortcut that

does not use a userid/password. The Users group has all

the privs that are needed for the application to

function. It appears that the application runs correctly

on every PC that is not an XP operating system. The XP

systems give the user the error "You do not have the

necessary permission to use" against one of the tables.

The table is the first one that is being opened by the

application but (whether this is related to the problem or

not, I don't know) it is an attached table from the second

mde file (not the one that the application initially

opens). I am perplexed, especially since I (and others)

have used the application without any problems on a number

of different machines that were not XP based. By the way,

in most cases the Access 2002 runtime is being installed

as part of the application installation. Thanks for your

help!!

******************************************



PLEASE HELP: I have a similar problem such as yours. I have a set of
MDE files that has been working for a while. All of the sudden, I see
all of them to be locked ( the ICON shows them locked). When I try to
access them, I get "" You do not have the necessary permission to use
the MDE object".

Someone suggested me to delete the LDB files and move these files to
another PC. I did such that and still having the same problem. Please
advice if you can.



Thanks ALex

 

[mig2000]

Originally posted by Ed

You can check if the user has Modify Design permission to the object;



It seems your database is using Access User level security. Check the

security for the local machine is pointing to a correct one.
"C" wrote in message

news:[email protected]"][email protected][/url]...

Hello. I have released an MS Access 2002 application that
consists of two MDE databases. I have "secured" the
application by following the procedure of using a
different workgroup info file to develop a user that is
the owner of the database and removing admins group
privileges from the Admin user while setting up the Admin
user to be a part of the normal Users group. The
application is released without the workgroup info file
and the users are accessing the form from a shortcut that
does not use a userid/password. The Users group has all
the privs that are needed for the application to
function. It appears that the application runs correctly
on every PC that is not an XP operating system. The XP
systems give the user the error "You do not have the
necessary permission to use" against one of the tables.
The table is the first one that is being opened by the
application but (whether this is related to the problem or
not, I don't know) it is an attached table from the second
mde file (not the one that the application initially
opens). I am perplexed, especially since I (and others)
have used the application without any problems on a number
of different machines that were not XP based. By the way,
in most cases the Access 2002 runtime is being installed
as part of the application installation. Thanks for your
help!!

*****************************************************



PLEASE HELP. I have a set of MDE files that has been working for a
while. All of the sudden, I see all of them to be locked ( the ICON
shows them locked). When I try to access them, I get "" You do not have
the necessary permission to use the MDE object".

Someone suggested me to delete the LDB files and move these files to
another PC. I did such that and still having the same problem. Please
advice if you can.



Thanks