Hey, I just installed the three service packs for access 2000 and no
when I try to open my secured database and log in as Admin it give
me the following error

"You do not have the necessary permissions to use the 'name.mdb
object. Have your system administrator or the person who created thi
object estacblish the appropriate permissions for you.

Also, when I try to log in as any of the users I had set up it no
says "Not a valid account or password". I assume that if I go back t
before the service packs it should work again, but does anyone hav
any idea why this would happen

I am getting very frustrated, please help! Thanks

Mat

"mattmanp" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hey, I just installed the three service packs for access 2000 and now
> when I try to open my secured database and log in as Admin it gives
> me the following error:
>
> "You do not have the necessary permissions to use the 'name.mdb'
> object. Have your system administrator or the person who created this
> object estacblish the appropriate permissions for you."

One would expect that the Admin user would not have any permissions.

> Also, when I try to log in as any of the users I had set up it now
> says "Not a valid account or password".

Are you logging in via a desktop shortcut, or just double-clicking the mdb
file?

Use Start, Run, wrkgadm.exe to check which workgroup file you are joined to
by default.


--
Joan Wild
Microsoft Access MVP

It worked for quite a while just clicking on the .mdb, but I hav
created a new .mdw file and created a desktop shortcut and it didn'
help. The user account I logged in on usually now says that th
account doesn't exist. I had manually created an Admin login in th
wizard that is what I was trying to log into. Thanks

"mattmanp" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It worked for quite a while just clicking on the .mdb, but I have
> created a new .mdw file and created a desktop shortcut and it didn't
> help.

You wouldn't need to create a new mdw file; just use the secure one you used
before. Your shortcut should have the following as the target:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"

" The user account I logged in on usually now says that the
> account doesn't exist.

That's because you aren't using the correct workgroup file.

> I had manually created an Admin login in the
> wizard that is what I was trying to log into. Thanks.

There is already a user named Admin; you can't create a second user with
that name. Please be specific. Do you mean you created a user with
administrative permissions?

Use Start, Search and locate all *.mdw files on your computer. What are
their paths?

User Start, Run, wrkgadm.exe to see what mdw you are currently joined to by
default. What is it?



--
Joan Wild
Microsoft Access MVP

Alright, it looks like a accidently deleted the mdw file a couple day
back (after problem started). I can't afford an access recover
person, is there anyways I can recreate the mdw file with nothing t
go on but the names that I put in the first time? I'm worried. Thank
for the help

I finally got it to prompt me, but it still doesn't give me access
Grrr

I have the desktop shortcut set up (have for a while), but it doesn'
prompt me for the user name and says I don't have permission. I hav
an account with administrative rights that is just my name, no
called admin, sorry

mattmanp wrote:
> Alright, it looks like a accidently deleted the mdw file a couple days
> back (after problem started). I can't afford an access recovery
> person, is there anyways I can recreate the mdw file with nothing to
> go on but the names that I put in the first time? I'm worried. Thanks
> for the help.

Nope. You need the ID values that were entered as well.

Did you check your recycle bin?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Yes... tried undelete software too... I think I'm screwed