wkgroup security

[teresaalmond]

I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!

[Tom van Stiphout]

On 16 Apr 2007 12:06:06 -0700, te**********@hotmail.com wrote:

That's because you've tinkered without first downloading, studying,
and fully understanding the Access Security FAQ from microsoft.com.
It's not like I haven't given this answer dozens of times. Sigh.

-Tom.

>I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!

[teresaalmond]

On Apr 17, 9:07 am, Tom van Stiphout <[e-mail]:

On 16 Apr 2007 12:06:06 -0700, [e-mail] wrote:

That's because you've tinkered without first downloading, studying,
and fully understanding the Access Security FAQ from microsoft.com.
It's not like I haven't given this answer dozens of times. Sigh.

-Tom.

I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!- Hide quoted text -

- Show quoted text -

Thanks, that was helpful

[teresaalmond]

Thanks, that was very helpful.
On Apr 17, 9:07 am, Tom van Stiphout <[e-mail]:

On 16 Apr 2007 12:06:06 -0700, [e-mail] wrote:

That's because you've tinkered without first downloading, studying,
and fully understanding the Access Security FAQ from microsoft.com.
It's not like I haven't given this answer dozens of times. Sigh.

-Tom.

I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!- Hide quoted text -

- Show quoted text -

[Keith Wilby]

<te**********@hotmail.comwrote in message
news:11**********************@d57g2000hsg.googlegr oups.com...

>I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!

http://support.microsoft.com/?id=207793

Keith.
www.keithwilby.com

[teresaalmond]

Ok, so I screwed up and ran the security wizard before following
instructions 1- 6 of that document

I've created a user name and added it to Admins. But, it doesn't
prompt for login, it still just does what it did before, I have no
permissions. Since it doesn't prompt for login so I can log in as the
user with admins, how am I going to get admins permissions?

I can't do anything.

Can you send me in the right direction to find out how to fix this and
'start over' the right way?
On Apr 17, 9:38 am, "Keith Wilby" <[e-mail]:

<[e-mail] in message

news:11**********************@d57g2000hsg.googlegr oups.com...

I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!

http://support.microsoft.com/?id=207793

Keith.www.keithwilby.com

[Keith Wilby]

<te**********@hotmail.comwrote in message
news:11********************@b58g2000hsg.googlegrou ps.com...

Ok, so I screwed up and ran the security wizard before following
instructions 1- 6 of that document

I've created a user name and added it to Admins. But, it doesn't
prompt for login, it still just does what it did before, I have no
permissions. Since it doesn't prompt for login so I can log in as the
user with admins, how am I going to get admins permissions?

I can't do anything.

Can you send me in the right direction to find out how to fix this and
'start over' the right way?

Did you take a backup before you started? If you used the wizard then it
should have created a backup for you (I think with a BAK extension). Can
you find one?

[salad]

Keith Wilby wrote:

<te**********@hotmail.comwrote in message
news:11********************@b58g2000hsg.googlegrou ps.com...

>>Ok, so I screwed up and ran the security wizard before following
instructions 1- 6 of that document

I've created a user name and added it to Admins. But, it doesn't
prompt for login, it still just does what it did before, I have no
permissions. Since it doesn't prompt for login so I can log in as the
user with admins, how am I going to get admins permissions?

I can't do anything.

Can you send me in the right direction to find out how to fix this and
'start over' the right way?

Did you take a backup before you started? If you used the wizard then it
should have created a backup for you (I think with a BAK extension). Can
you find one?

Keith, I was wondering what would happen if she got a "blank" system.mdw
installed onto her computer...iow reinstall Access. Most likely she
was connected to the system.mdw on her computer. Would a new, blank
copy help?

[teresaalmond]

On Apr 17, 10:38 am, "Keith Wilby" <[e-mail]:

<[e-mail] in message

news:11********************@b58g2000hsg.googlegrou ps.com...

Ok, so I screwed up and ran the security wizard before following
instructions 1- 6 of that document

I've created a user name and added it to Admins. But, it doesn't
prompt for login, it still just does what it did before, I have no
permissions. Since it doesn't prompt for login so I can log in as the
user with admins, how am I going to get admins permissions?

I can't do anything.

Can you send me in the right direction to find out how to fix this and
'start over' the right way?

Did you take a backup before you started? If you used the wizard then it
should have created a backup for you (I think with a BAK extension). Can
you find one?

Yes, I've found the .bak of the database.

I also thought about getting a system.mdw from another pc and
overwriting the one on my pc, would that work?

[teresaalmond]

On Apr 17, 12:15 pm, [e-mail] wrote:

On Apr 17, 10:38 am, "Keith Wilby" <[e-mail]:

<[e-mail] in message

news:11********************@b58g2000hsg.googlegrou ps.com...

Ok, so I screwed up and ran the security wizard before following
instructions 1- 6 of that document

I've created a user name and added it to Admins. But, it doesn't
prompt for login, it still just does what it did before, I have no
permissions. Since it doesn't prompt for login so I can log in as the
user with admins, how am I going to get admins permissions?

I can't do anything.

Can you send me in the right direction to find out how to fix this and
'start over' the right way?

Did you take a backup before you started? If you used the wizard then it
should have created a backup for you (I think with a BAK extension). Can
you find one?

Yes, I've found the .bak of the database.

I also thought about getting a system.mdw from another pc and
overwriting the one on my pc, would that work?- Hide quoted text -

- Show quoted text -

OK.. now all other Access databases, including the one I tried to set
up security on, ask for a user and password. The one that I did set
up doesn't work, and I'm sure it should. I wrote down, and it is
something I use all the time.

[teresaalmond]

On Apr 17, 3:12 pm, [e-mail] wrote:

On Apr 17, 12:15 pm, [e-mail] wrote:

On Apr 17, 10:38 am, "Keith Wilby" <[e-mail]:

<[e-mail] in message

>news:11********************@b58g2000hsg.googlegro ups.com...

Ok, so I screwed up and ran the security wizard before following
instructions 1- 6 of that document

I've created a user name and added it to Admins. But, it doesn't
prompt for login, it still just does what it did before, I have no
permissions. Since it doesn't prompt for login so I can log in as the
user with admins, how am I going to get admins permissions?

I can't do anything.

Can you send me in the right direction to find out how to fix this and
'start over' the right way?

Did you take a backup before you started? If you used the wizard then it
should have created a backup for you (I think with a BAK extension). Can
you find one?

Yes, I've found the .bak of the database.

I also thought about getting a system.mdw from another pc and
overwriting the one on my pc, would that work?- Hide quoted text -

- Show quoted text -

OK.. now all other Access databases, including the one I tried to set
up security on, ask for a user and password. The one that I did set
up doesn't work, and I'm sure it should. I wrote down, and it is
something I use all the time.- Hide quoted text -

- Show quoted text -

Ok, I give up.
All of my databases ask for the login that I set up on the 1st one. I
remembered that there is no password set yet, so at least I can get
into those.

but the first database still won't let me do a thing.

[Rick Brandt]

te**********@hotmail.com wrote:

Ok, I give up.
All of my databases ask for the login that I set up on the 1st one. I
remembered that there is no password set yet, so at least I can get
into those.

but the first database still won't let me do a thing.

Access security is not "applied to a file". It affects the session. When
you open an Access session you either do so using a workgroup that requires
you to log in or you do so with a workgroup that does not require a login.
That part (logging in or not) has absolutely nothing to do with the files
you might try to use during the session. This is one of the complexities of
the Access security model and one of the areas that people get most confused
about.

If you are asked to login when you start Access then that means that your
default workgroup that you are currently joined to requires a login. That's
all it means. If you make a different workgroup file your default (one that
dosn't require a login) then the login prompts will go away and you will be
silently logged into the session as the user "Admin".

Now, if you do that and then try to open a file where "Admin" has no
permissions then you won't be able to open that file. That is what matters
about the file (who has permissions to do what). The mdb file has no
control over whether you are prompted for a login or not. All it cares
about is who the current session user is and what groups that the current
session user belongs to.

If you make System.MDW your default workgroup file then everything should go
back to the way it was before you started tinkering (provided that you use
the BAK copy of your original file).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Tom van Stiphout]

On 17 Apr 2007 07:32:11 -0700, te**********@hotmail.com wrote:

I wish MSFT would quit offering the security options. It's too easy to
get in a state like you are now, and then you're frustrated about a "I
told you so" message, probably because you never ever saw it. And MSFT
didn't warn you that this is an advanced topic you should not venture
into without full understanding.

With Access 2007, I got my wish.

-Tom.

>On Apr 17, 9:07 am, Tom van Stiphout <[e-mail]:

>On 16 Apr 2007 12:06:06 -0700, [e-mail] wrote:

That's because you've tinkered without first downloading, studying,
and fully understanding the Access Security FAQ from microsoft.com.
It's not like I haven't given this answer dozens of times. Sigh.

-Tom.

>I only took the initial steps to set up security. I haven't set up
passwords or specific permissions on any tables, queries etc. My
problem is, I dont have permission to do any of the above! I can't
open anything in the database in design or regular view, I can't set a
password or permissions for anything, I can't import the tables from
another database or export from this one, it says I don't have
permission, help!!- Hide quoted text -

- Show quoted text -

Thanks, that was helpful

[Tom van Stiphout]

On Tue, 17 Apr 2007 16:03:06 -0500, "Rick Brandt"
<ri*********@hotmail.comwrote:

Rick could be right, or you may have changed your default workgroup.
You set the default workgroup using the wrkgadm.exe application.

-Tom.

>te**********@hotmail.com wrote:

>Ok, I give up.
All of my databases ask for the login that I set up on the 1st one. I
remembered that there is no password set yet, so at least I can get
into those.

but the first database still won't let me do a thing.

Access security is not "applied to a file". It affects the session. When
you open an Access session you either do so using a workgroup that requires
you to log in or you do so with a workgroup that does not require a login.
That part (logging in or not) has absolutely nothing to do with the files
you might try to use during the session. This is one of the complexities of
the Access security model and one of the areas that people get most confused
about.

If you are asked to login when you start Access then that means that your
default workgroup that you are currently joined to requires a login. That's
all it means. If you make a different workgroup file your default (one that
dosn't require a login) then the login prompts will go away and you will be
silently logged into the session as the user "Admin".

Now, if you do that and then try to open a file where "Admin" has no
permissions then you won't be able to open that file. That is what matters
about the file (who has permissions to do what). The mdb file has no
control over whether you are prompted for a login or not. All it cares
about is who the current session user is and what groups that the current
session user belongs to.

If you make System.MDW your default workgroup file then everything should go
back to the way it was before you started tinkering (provided that you use
the BAK copy of your original file).

[Keith Wilby]

"salad" <oi*@vinegar.comwrote in message
news:Mz*****************@newsread1.news.pas.earthl ink.net...

Keith Wilby wrote:

>>

Did you take a backup before you started? If you used the wizard then it
should have created a backup for you (I think with a BAK extension). Can
you find one?

Keith, I was wondering what would happen if she got a "blank" system.mdw
installed onto her computer...iow reinstall Access. Most likely she was
connected to the system.mdw on her computer. Would a new, blank copy
help?

Hi salad,

Yes it will help if the OP has a backup of their original mdb. IIRC A2k
onwards will create a new pristine system.mdw if it can't find one on
startup, so renaming the old one is worth trying.

Keith.