"VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in message
news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
>I have a user-level secured Access 2002-2003 database.  I was able to
>access
> it this morning, but after clearing the 'Admin' user password can't access
> the database, receiving the following:
>
> "You do not have the necessary permissions to use the <name> object. Have
> your system administrator or the person who created this object establish
> the
> appropriate permissions for you. (Error 3033)"
>
> I was successfully launching the database before with a VBScript that I
> wrote myself.
>
> Please help!!
>
> VBA Dabbler

"Lynn Trapp" wrote:

> Why did you clear out the Admin user's password? When you did that, you are
> causing Access to log in silent as the Admin user and, apparently, you
> removed all of the Admin user's permissions.
>
> --
> Lynn Trapp
> MS Access MVP
> www.ltcomputerdesigns.com
> Access Security: www.ltcomputerdesigns.com/Security.htm
> Jeff Conrad's Access Junkie List:
> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>
>
>
> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in message
> news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
> >I have a user-level secured Access 2002-2003 database.  I was able to
> >access
> > it this morning, but after clearing the 'Admin' user password can't access
> > the database, receiving the following:
> >
> > "You do not have the necessary permissions to use the <name> object. Have
> > your system administrator or the person who created this object establish
> > the
> > appropriate permissions for you. (Error 3033)"
> >
> > I was successfully launching the database before with a VBScript that I
> > wrote myself.
> >
> > Please help!!
> >
> > VBA Dabbler
>
>
>

> Hi Lynn,
>
> I thought the 'Admin' account should be removed.  I did not touch
> permissions for the account, just cleared the password.
>
> I also found out that the 'Admin' account can't be deleted - Access
> wouldn't allow it.
>
> However, is there a way to recover from this or do I need to recreate
> the database.
>
> Obviously this is an area I need to do some brushup reading on.  Any
> suggestions?
>
> Regards,
>
> VBA Dabbler
>
> "Lynn Trapp" wrote:
>
>> Why did you clear out the Admin user's password? When you did that,
>> you are causing Access to log in silent as the Admin user and,
>> apparently, you removed all of the Admin user's permissions.
>>
>> --
>> Lynn Trapp
>> MS Access MVP
>> www.ltcomputerdesigns.com
>> Access Security: www.ltcomputerdesigns.com/Security.htm
>> Jeff Conrad's Access Junkie List:
>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>
>>
>>
>> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in message
>> news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
>>> I have a user-level secured Access 2002-2003 database.  I was able
>>> to access
>>> it this morning, but after clearing the 'Admin' user password can't
>>> access the database, receiving the following:
>>>
>>> "You do not have the necessary permissions to use the <name>
>>> object. Have your system administrator or the person who created
>>> this object establish the
>>> appropriate permissions for you. (Error 3033)"
>>>
>>> I was successfully launching the database before with a VBScript
>>> that I wrote myself.
>>>
>>> Please help!!
>>>
>>> VBA Dabbler

"Joan Wild" wrote:

> Open your secure mdb via your shortcut - dismiss the message about no
> permissions.
>
> Go to tools, security, accounts and click on Change password tab.  Admin
> should be listed as the current user - provide a password for Admin.  Since
> you used your shortcut, you should be using your secure workgorup file.
>
> Setting a password for Admin is what causes the dialog to show up.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> VBA Dabbler wrote:
> > Hi Lynn,
> >
> > I thought the 'Admin' account should be removed.  I did not touch
> > permissions for the account, just cleared the password.
> >
> > I also found out that the 'Admin' account can't be deleted - Access
> > wouldn't allow it.
> >
> > However, is there a way to recover from this or do I need to recreate
> > the database.
> >
> > Obviously this is an area I need to do some brushup reading on.  Any
> > suggestions?
> >
> > Regards,
> >
> > VBA Dabbler
> >
> > "Lynn Trapp" wrote:
> >
> >> Why did you clear out the Admin user's password? When you did that,
> >> you are causing Access to log in silent as the Admin user and,
> >> apparently, you removed all of the Admin user's permissions.
> >>
> >> --
> >> Lynn Trapp
> >> MS Access MVP
> >> www.ltcomputerdesigns.com
> >> Access Security: www.ltcomputerdesigns.com/Security.htm
> >> Jeff Conrad's Access Junkie List:
> >> http://home.bendbroadband.com/conradsystems/accessjunkie.html
> >>
> >>
> >>
> >> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in message
> >> news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
> >>> I have a user-level secured Access 2002-2003 database.  I was able
> >>> to access
> >>> it this morning, but after clearing the 'Admin' user password can't
> >>> access the database, receiving the following:
> >>>
> >>> "You do not have the necessary permissions to use the <name>
> >>> object. Have your system administrator or the person who created
> >>> this object establish the
> >>> appropriate permissions for you. (Error 3033)"
> >>>
> >>> I was successfully launching the database before with a VBScript
> >>> that I wrote myself.
> >>>
> >>> Please help!!
> >>>
> >>> VBA Dabbler
>
>
>

> Thanks for your reply Joan.
>
> Unfortunately I just got your message, and before you replied, I had
> already reconstructed from scratch.
>
> However, I have a followup question on your recommendation....
>
> What would prevent anyone from setting the password for Admin in this
> case? Is the database vunerable to unsecured access?
>
> Regards,
>
> VBA Dabbler
>
> "Joan Wild" wrote:
>
>> Open your secure mdb via your shortcut - dismiss the message about no
>> permissions.
>>
>> Go to tools, security, accounts and click on Change password tab.
>> Admin should be listed as the current user - provide a password for
>> Admin.  Since you used your shortcut, you should be using your
>> secure workgorup file.
>>
>> Setting a password for Admin is what causes the dialog to show up.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> VBA Dabbler wrote:
>>> Hi Lynn,
>>>
>>> I thought the 'Admin' account should be removed.  I did not touch
>>> permissions for the account, just cleared the password.
>>>
>>> I also found out that the 'Admin' account can't be deleted - Access
>>> wouldn't allow it.
>>>
>>> However, is there a way to recover from this or do I need to
>>> recreate the database.
>>>
>>> Obviously this is an area I need to do some brushup reading on.  Any
>>> suggestions?
>>>
>>> Regards,
>>>
>>> VBA Dabbler
>>>
>>> "Lynn Trapp" wrote:
>>>
>>>> Why did you clear out the Admin user's password? When you did that,
>>>> you are causing Access to log in silent as the Admin user and,
>>>> apparently, you removed all of the Admin user's permissions.
>>>>
>>>> --
>>>> Lynn Trapp
>>>> MS Access MVP
>>>> www.ltcomputerdesigns.com
>>>> Access Security: www.ltcomputerdesigns.com/Security.htm
>>>> Jeff Conrad's Access Junkie List:
>>>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>>>
>>>>
>>>>
>>>> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in
>>>> message news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
>>>>> I have a user-level secured Access 2002-2003 database.  I was able
>>>>> to access
>>>>> it this morning, but after clearing the 'Admin' user password
>>>>> can't access the database, receiving the following:
>>>>>
>>>>> "You do not have the necessary permissions to use the <name>
>>>>> object. Have your system administrator or the person who created
>>>>> this object establish the
>>>>> appropriate permissions for you. (Error 3033)"
>>>>>
>>>>> I was successfully launching the database before with a VBScript
>>>>> that I wrote myself.
>>>>>
>>>>> Please help!!
>>>>>
>>>>> VBA Dabbler

"Joan Wild" wrote:

> In your case, you had cleared the Admin password.  Therefore you got no
> login dialog, and were silently logged in as Admin.
>
> Once you set a password for Admin, then in order to change it, one would
> need to login as Admin (with the correct password) and then change it.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> VBA Dabbler wrote:
> > Thanks for your reply Joan.
> >
> > Unfortunately I just got your message, and before you replied, I had
> > already reconstructed from scratch.
> >
> > However, I have a followup question on your recommendation....
> >
> > What would prevent anyone from setting the password for Admin in this
> > case? Is the database vunerable to unsecured access?
> >
> > Regards,
> >
> > VBA Dabbler
> >
> > "Joan Wild" wrote:
> >
> >> Open your secure mdb via your shortcut - dismiss the message about no
> >> permissions.
> >>
> >> Go to tools, security, accounts and click on Change password tab.
> >> Admin should be listed as the current user - provide a password for
> >> Admin.  Since you used your shortcut, you should be using your
> >> secure workgorup file.
> >>
> >> Setting a password for Admin is what causes the dialog to show up.
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> VBA Dabbler wrote:
> >>> Hi Lynn,
> >>>
> >>> I thought the 'Admin' account should be removed.  I did not touch
> >>> permissions for the account, just cleared the password.
> >>>
> >>> I also found out that the 'Admin' account can't be deleted - Access
> >>> wouldn't allow it.
> >>>
> >>> However, is there a way to recover from this or do I need to
> >>> recreate the database.
> >>>
> >>> Obviously this is an area I need to do some brushup reading on.  Any
> >>> suggestions?
> >>>
> >>> Regards,
> >>>
> >>> VBA Dabbler
> >>>
> >>> "Lynn Trapp" wrote:
> >>>
> >>>> Why did you clear out the Admin user's password? When you did that,
> >>>> you are causing Access to log in silent as the Admin user and,
> >>>> apparently, you removed all of the Admin user's permissions.
> >>>>
> >>>> --
> >>>> Lynn Trapp
> >>>> MS Access MVP
> >>>> www.ltcomputerdesigns.com
> >>>> Access Security: www.ltcomputerdesigns.com/Security.htm
> >>>> Jeff Conrad's Access Junkie List:
> >>>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
> >>>>
> >>>>
> >>>>
> >>>> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in
> >>>> message news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
> >>>>> I have a user-level secured Access 2002-2003 database.  I was able
> >>>>> to access
> >>>>> it this morning, but after clearing the 'Admin' user password
> >>>>> can't access the database, receiving the following:
> >>>>>
> >>>>> "You do not have the necessary permissions to use the <name>
> >>>>> object. Have your system administrator or the person who created
> >>>>> this object establish the
> >>>>> appropriate permissions for you. (Error 3033)"
> >>>>>
> >>>>> I was successfully launching the database before with a VBScript
> >>>>> that I wrote myself.
> >>>>>
> >>>>> Please help!!
> >>>>>
> >>>>> VBA Dabbler
>
>
>

> Hi MS Access gurus,
>
> I did some stupid thing. Tried so many options and get the same error
> message as lsited on this post. How do I get rid of it and recover my
> database which I just can't access now..
>
> Jodi
>
> "Joan Wild" wrote:
>
>> In your case, you had cleared the Admin password.  Therefore you got
>> no login dialog, and were silently logged in as Admin.
>>
>> Once you set a password for Admin, then in order to change it, one
>> would need to login as Admin (with the correct password) and then
>> change it.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> VBA Dabbler wrote:
>>> Thanks for your reply Joan.
>>>
>>> Unfortunately I just got your message, and before you replied, I had
>>> already reconstructed from scratch.
>>>
>>> However, I have a followup question on your recommendation....
>>>
>>> What would prevent anyone from setting the password for Admin in
>>> this case? Is the database vunerable to unsecured access?
>>>
>>> Regards,
>>>
>>> VBA Dabbler
>>>
>>> "Joan Wild" wrote:
>>>
>>>> Open your secure mdb via your shortcut - dismiss the message about
>>>> no permissions.
>>>>
>>>> Go to tools, security, accounts and click on Change password tab.
>>>> Admin should be listed as the current user - provide a password for
>>>> Admin.  Since you used your shortcut, you should be using your
>>>> secure workgorup file.
>>>>
>>>> Setting a password for Admin is what causes the dialog to show up.
>>>>
>>>>
>>>> --
>>>> Joan Wild
>>>> Microsoft Access MVP
>>>>
>>>> VBA Dabbler wrote:
>>>>> Hi Lynn,
>>>>>
>>>>> I thought the 'Admin' account should be removed.  I did not touch
>>>>> permissions for the account, just cleared the password.
>>>>>
>>>>> I also found out that the 'Admin' account can't be deleted -
>>>>> Access wouldn't allow it.
>>>>>
>>>>> However, is there a way to recover from this or do I need to
>>>>> recreate the database.
>>>>>
>>>>> Obviously this is an area I need to do some brushup reading on.
>>>>> Any suggestions?
>>>>>
>>>>> Regards,
>>>>>
>>>>> VBA Dabbler
>>>>>
>>>>> "Lynn Trapp" wrote:
>>>>>
>>>>>> Why did you clear out the Admin user's password? When you did
>>>>>> that, you are causing Access to log in silent as the Admin user
>>>>>> and, apparently, you removed all of the Admin user's permissions.
>>>>>>
>>>>>> --
>>>>>> Lynn Trapp
>>>>>> MS Access MVP
>>>>>> www.ltcomputerdesigns.com
>>>>>> Access Security: www.ltcomputerdesigns.com/Security.htm
>>>>>> Jeff Conrad's Access Junkie List:
>>>>>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
>>>>>>
>>>>>>
>>>>>>
>>>>>> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in
>>>>>> message
>>>>>> news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
>>>>>>> I have a user-level secured Access 2002-2003 database.  I was
>>>>>>> able to access
>>>>>>> it this morning, but after clearing the 'Admin' user password
>>>>>>> can't access the database, receiving the following:
>>>>>>>
>>>>>>> "You do not have the necessary permissions to use the <name>
>>>>>>> object. Have your system administrator or the person who created
>>>>>>> this object establish the
>>>>>>> appropriate permissions for you. (Error 3033)"
>>>>>>>
>>>>>>> I was successfully launching the database before with a VBScript
>>>>>>> that I wrote myself.
>>>>>>>
>>>>>>> Please help!!
>>>>>>>
>>>>>>> VBA Dabbler

"Joan Wild" wrote:

> I think you need to clarify what error message you are getting, and what you
> did.
>
> Did you clear the Admin password?  Did you restore it as suggested by
> earlier posts?
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Jodi wrote:
> > Hi MS Access gurus,
> >
> > I did some stupid thing. Tried so many options and get the same error
> > message as lsited on this post. How do I get rid of it and recover my
> > database which I just can't access now..
> >
> > Jodi
> >
> > "Joan Wild" wrote:
> >
> >> In your case, you had cleared the Admin password.  Therefore you got
> >> no login dialog, and were silently logged in as Admin.
> >>
> >> Once you set a password for Admin, then in order to change it, one
> >> would need to login as Admin (with the correct password) and then
> >> change it.
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> VBA Dabbler wrote:
> >>> Thanks for your reply Joan.
> >>>
> >>> Unfortunately I just got your message, and before you replied, I had
> >>> already reconstructed from scratch.
> >>>
> >>> However, I have a followup question on your recommendation....
> >>>
> >>> What would prevent anyone from setting the password for Admin in
> >>> this case? Is the database vunerable to unsecured access?
> >>>
> >>> Regards,
> >>>
> >>> VBA Dabbler
> >>>
> >>> "Joan Wild" wrote:
> >>>
> >>>> Open your secure mdb via your shortcut - dismiss the message about
> >>>> no permissions.
> >>>>
> >>>> Go to tools, security, accounts and click on Change password tab.
> >>>> Admin should be listed as the current user - provide a password for
> >>>> Admin.  Since you used your shortcut, you should be using your
> >>>> secure workgorup file.
> >>>>
> >>>> Setting a password for Admin is what causes the dialog to show up.
> >>>>
> >>>>
> >>>> --
> >>>> Joan Wild
> >>>> Microsoft Access MVP
> >>>>
> >>>> VBA Dabbler wrote:
> >>>>> Hi Lynn,
> >>>>>
> >>>>> I thought the 'Admin' account should be removed.  I did not touch
> >>>>> permissions for the account, just cleared the password.
> >>>>>
> >>>>> I also found out that the 'Admin' account can't be deleted -
> >>>>> Access wouldn't allow it.
> >>>>>
> >>>>> However, is there a way to recover from this or do I need to
> >>>>> recreate the database.
> >>>>>
> >>>>> Obviously this is an area I need to do some brushup reading on.
> >>>>> Any suggestions?
> >>>>>
> >>>>> Regards,
> >>>>>
> >>>>> VBA Dabbler
> >>>>>
> >>>>> "Lynn Trapp" wrote:
> >>>>>
> >>>>>> Why did you clear out the Admin user's password? When you did
> >>>>>> that, you are causing Access to log in silent as the Admin user
> >>>>>> and, apparently, you removed all of the Admin user's permissions.
> >>>>>>
> >>>>>> --
> >>>>>> Lynn Trapp
> >>>>>> MS Access MVP
> >>>>>> www.ltcomputerdesigns.com
> >>>>>> Access Security: www.ltcomputerdesigns.com/Security.htm
> >>>>>> Jeff Conrad's Access Junkie List:
> >>>>>> http://home.bendbroadband.com/conradsystems/accessjunkie.html
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> "VBA Dabbler" <VBADabb***@discussions.microsoft.com> wrote in
> >>>>>> message
> >>>>>> news:4BCFE210-7F56-4398-AD09-A1F4D27F04B3@microsoft.com...
> >>>>>>> I have a user-level secured Access 2002-2003 database.  I was
> >>>>>>> able to access
> >>>>>>> it this morning, but after clearing the 'Admin' user password
> >>>>>>> can't access the database, receiving the following:
> >>>>>>>
> >>>>>>> "You do not have the necessary permissions to use the <name>
> >>>>>>> object. Have your system administrator or the person who created
> >>>>>>> this object establish the
> >>>>>>> appropriate permissions for you. (Error 3033)"
> >>>>>>>
> >>>>>>> I was successfully launching the database before with a VBScript
> >>>>>>> that I wrote myself.
> >>>>>>>
> >>>>>>> Please help!!
> >>>>>>>
> >>>>>>> VBA Dabbler
>
>
>

> I get the same error message as VBA Dabbler is getting. I did set a
> password again and also joined the workgroup.
>
>
>
> "Joan Wild" wrote:
>
>> I think you need to clarify what error message you are getting, and
>> what you did.
>>
>> Did you clear the Admin password?  Did you restore it as suggested by
>> earlier posts?
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>

"Joan Wild" wrote:

> So the message you are getting is
> "You do not have the necessary permissions to use the <name>
> object. Have your system administrator or the person who created
>  this object establish the
>  appropriate permissions for you. (Error 3033)"
>
> That doesn't necessarily mean you cleared the password for the Admin user
> (which VBA Dabbler did).
>
> In your case, you likely are not using the correct workgroup file (mdw).  Do
> a search on your computer for all *.mdw files and note their paths.
>
> Open Access and go to Tools, Security, Workgroup Administrator.  That will
> tell you the workgroup you are joined to by default.  It should be the
> system.mdw that ships with Access (it's usually found in the windows system
> folder, but you'll find it in the list above).
>
> You do not want to set a password for Admin in this workgroup file!.  You
> need to leave it as is in order for non-secured databases to work.
>
> You need to create a desktop shortcut (if you used the wizard it created one
> for you), that has the following in the target:
> "path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"
>
> Try each of the mdw files you found above.
>
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Jodi wrote:
> > I get the same error message as VBA Dabbler is getting. I did set a
> > password again and also joined the workgroup.
> >
> >
> >
> > "Joan Wild" wrote:
> >
> >> I think you need to clarify what error message you are getting, and
> >> what you did.
> >>
> >> Did you clear the Admin password?  Did you restore it as suggested by
> >> earlier posts?
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
>
>
>

> It displays my name in the workgroup file when I open Access. I
> searched and joined all the mdw workgroups.
>
> "Joan Wild" wrote:
>
>> So the message you are getting is
>> "You do not have the necessary permissions to use the <name>
>> object. Have your system administrator or the person who created
>>  this object establish the
>>  appropriate permissions for you. (Error 3033)"
>>
>> That doesn't necessarily mean you cleared the password for the Admin
>> user (which VBA Dabbler did).
>>
>> In your case, you likely are not using the correct workgroup file
>> (mdw).  Do a search on your computer for all *.mdw files and note
>> their paths.
>>
>> Open Access and go to Tools, Security, Workgroup Administrator.
>> That will tell you the workgroup you are joined to by default.  It
>> should be the system.mdw that ships with Access (it's usually found
>> in the windows system folder, but you'll find it in the list above).
>>
>> You do not want to set a password for Admin in this workgroup file!.
>> You need to leave it as is in order for non-secured databases to
>> work.
>>
>> You need to create a desktop shortcut (if you used the wizard it
>> created one for you), that has the following in the target:
>> "path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure
>> mdw"
>>
>> Try each of the mdw files you found above.
>>
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Jodi wrote:
>>> I get the same error message as VBA Dabbler is getting. I did set a
>>> password again and also joined the workgroup.
>>>
>>>
>>>
>>> "Joan Wild" wrote:
>>>
>>>> I think you need to clarify what error message you are getting, and
>>>> what you did.
>>>>
>>>> Did you clear the Admin password?  Did you restore it as suggested
>>>> by earlier posts?
>>>>
>>>>
>>>> --
>>>> Joan Wild
>>>> Microsoft Access MVP