Users and Permissions disabled

1 Oct 2007 3:23 PM

CBKowitz

We are using Access 2007 with an .accdb. We've set the default workgroup and
now we want to add/update users. But the Users and Permissions menu option
is greyed out. Even logged in as Admin, same problem. Any ideas?

Thanks.

1 Oct 2007 3:32 PM

'69 Camaro

Hi.

> We are using Access 2007 with an .accdb. We've set the default workgroup
> and
> now we want to add/update users. But the Users and Permissions menu
> option
> is greyed out.

You'll have to convert the database file to an MDB file. User-Level
Security has not been implemented for the new ACCDB file format.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

1 Oct 2007 3:50 PM

CBKowitz

Thanks that was the missing piece. We just needed access to create a new user.

Show quote

"'69 Camaro" wrote:

> Hi.
>
> > We are using Access 2007 with an .accdb. We've set the default workgroup
> > and
> > now we want to add/update users. But the Users and Permissions menu
> > option
> > is greyed out.
>
> You'll have to convert the database file to an MDB file. User-Level
> Security has not been implemented for the new ACCDB file format.
>
> HTH.
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
> Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
> info.
>
>
>

1 Oct 2007 4:00 PM

Rick Brandt

CBKowitz wrote:

> We are using Access 2007 with an .accdb. We've set the default
> workgroup and now we want to add/update users. But the Users and
> Permissions menu option is greyed out. Even logged in as Admin, same
> problem. Any ideas?
>
> Thanks.

The new AccDB file format no longer supports User Level Security. You have
to stay with an MDB file if you want that.

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