AW: [AccessD] Remove Security

Richard,

I don't know if that works but it might be worth trying:

You can specify user and password on the command line. That way you might be
able to open your MDB as a specific user even if the admin password has been
cleared.

Also, there are tools out there that can 'recover' user names and passwords
from the mdw file (I don't know of any tool that recovers the SID as
well...).

You definitely have a problem if you do not have the mdw file or if the user
account you need has been deleted from the mdw file.

HTH,


Michael

-----Ursprüngliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Griffiths,
Richard
Gesendet: Freitag, 11. April 2003 11:40
An: 'accessd at databaseadvisors.com'
Betreff: RE: [AccessD] Remove Security


As I just found out the clearing of the Admin password simply removes the
prompt to enter user/password when Access loads - it does not remove
security - (its seems you are 'logged on' as the User (user) which in my app
did not have any permissions - to get the password back and the prompt you
need persmission to do so, which I no longer have - I had to restore my mdw
file to get back to where I was - anyway I think I'm going to abandon this
one and revisit when my head clears.
Richard

> -----Original Message-----
> From:	Roz Clarke [SMTP:roz.clarke at donnslaw.co.uk]
> Sent:	11 April 2003 10:26
> To:	'accessd at databaseadvisors.com'
> Subject:	RE: [AccessD] Remove Security
>
> I'm a bit rusty on Access security, but as I recall, it depends on what
> sort
> of security was set up. By default, with a new install of Access security
> is
> not activated. Once it is activated however, if any user accounts bar the
> admin account have been created, you have to concern yourself with
> workgroups. The A97 Help file is fairly good on the subject.
>
> Roz
>
> -----Original Message-----
> From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk]
> Sent: 11 April 2003 10:10
> To: 'AccessD at databaseadvisors.com'
> Subject: [AccessD] Remove Security
>
>
> Hi
>
> A97
>
> Do i simply remove/clear the admin password to remove access internal
> security? If not what else is required?
>
> Thanks
>
> Richard
> --------------------------------------------------------------------------
> --
> ----------------------------------------
> This e-mail, together with any files transmitted with it, is confidential
> and intended solely for the use of the individual to whom it is addressed.
> If you are not the intended recipient, or the person responsible for
> delivering to the intended recipient, be advised that you have received
> this
> e-mail in error and that any use, dissemination, forwarding, printing or
> copying of this e-mail is strictly prohibited without liability on our
> part.
>
> By responding to this e-mail it is accepted that your response
> may be the subject of recording/monitoring to ensure compliance
> with the Council's ICT Security Policy
>
> If you have received this e-mail in error please notify the sender.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
----------------------------------------------------------------------------
----------------------------------------
This e-mail, together with any files transmitted with it, is
confidential and intended solely for the use of the individual to
whom it is addressed. If you are not the intended recipient, or
the person responsible for delivering to the intended recipient,
be advised that you have received this e-mail in error and that any
use, dissemination, forwarding, printing or copying of this e-mail
is strictly prohibited without liability on our part.

By responding to this e-mail it is accepted that your response
may be the subject of recording/monitoring to ensure compliance
with the Council’s ICT Security Policy

If you have received this e-mail in error please notify the sender.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com