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!!

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" <(E-Mail Removed)> wrote in message
news:015901c34d61$12777150$(E-Mail Removed)...
> 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!!

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?

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" <(E-Mail Removed)>
| Sender: "C" <(E-Mail Removed)>
| 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?
|
|

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


--
Posted via http://dbforums.com

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:015901c34d61$12777150$(E-Mail Removed)"]news:015901c34d61$-
> 12777150$(E-Mail Removed)[/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


--
Posted via http://dbforums.com