User Permissions in Access 2007 DB

[Nick Coppola]

Hi,

I'm having some trouble understanding the changes related to security in
Access 2007. I have a business need whereby, like many others, we had an
Access 2003 database that used an MDW to restrict access to objects based
upon the logged-in user. Understanding that the use of an MDW is gone in
2007 for accdb files, is it incorrect to assume the same users that existed
in the MDW couldn't be setup as users and permissions set on the objects?

We tried creating a new 2007 DB, gave the Admin a password, and then
imported all the objects from an Access 2003 DB that used user level security.

We now appear to have an Access 2007 DB, that enforces the permissions as it
had been doing in 2003. Is this by design or not?

On an aside, I've been a SQL Server developer for years and never spent all
that much time with Access. It is only recently that the need presented
itself and the idea that you cannot set permissions to more than one user
within a database just seems absolutely crazy...

Thanks,

- Nick

 

[Keith Wilby]

Hi,

I'm having some trouble understanding the changes related to security in
Access 2007. I have a business need whereby, like many others, we had an
Access 2003 database that used an MDW to restrict access to objects based
upon the logged-in user. Understanding that the use of an MDW is gone in
2007 for accdb files, is it incorrect to assume the same users that
existed
in the MDW couldn't be setup as users and permissions set on the objects?

We tried creating a new 2007 DB, gave the Admin a password, and then
imported all the objects from an Access 2003 DB that used user level
security.

We now appear to have an Access 2007 DB, that enforces the permissions as
it
had been doing in 2003. Is this by design or not?

AIUI A2007 supports ULS provided that you stick to the MDB format.

On an aside, I've been a SQL Server developer for years and never spent
all
that much time with Access. It is only recently that the need presented
itself and the idea that you cannot set permissions to more than one user
within a database just seems absolutely crazy...

What makes you think that you can't set permissions for more than one user?

Keith.
www.keithwilby.com

 

[Nick Coppola]

:

AIUI A2007 supports ULS provided that you stick to the MDB format.

(AIUI)??? I understand, but wasn't clear on whether retaining ULS also
mean't keeping the database format Access 2003 and mdb.

The database that we are currently working with is in fact a .accdb

What makes you think that you can't set permissions for more than one user?

I believe that's my point, to me true user level security means just that...
When I hear ULS has been removed, I understand that to mean all users will
have full access to all objects in the database. SQL Server has allowed us
to establish priveleges at the user level and I'd expect the same from Access
2007.

Am I understanding this incorrectly? So, when they say ULS was removed,
what exactly was removed? is it the association with a MDW file? It would
seem to me that Access 2007 could import such security.

Keith - I really am sorry if I'm missing something obvious here. Can you
shed some additional light??? It seems to be a fairly common question...

Thanks,

- Nick

 

[Keith Wilby]

(AIUI)??? I understand, but wasn't clear on whether retaining ULS also
mean't keeping the database format Access 2003 and mdb.

Yes, you must keep to the mdb format to retain ULS AIUI (as *I* undersatnd
it, I wasn't implying that you didn't understand ;-))

The database that we are currently working with is in fact a .accdb

Then I believe you've lost ULS on that file.

I believe that's my point, to me true user level security means just
that...
When I hear ULS has been removed, I understand that to mean all users will
have full access to all objects in the database.

Yes I believe that's the case - I'm just going off what I've read about
A2007 on here, I don't have it myself (and I don't like the sound of it to
be honest).

SQL Server has allowed us
to establish priveleges at the user level and I'd expect the same from
Access
2007.

Am I understanding this incorrectly? So, when they say ULS was removed,
what exactly was removed? is it the association with a MDW file? It would
seem to me that Access 2007 could import such security.

Keith - I really am sorry if I'm missing something obvious here. Can you
shed some additional light??? It seems to be a fairly common question...

Just to reiterate - ULS allows for security at object/user level and IS
supported by A2007 provided that you keep to the mdb format. You will lose
ULS if you convert to the new file format. AIUI ;-)

Regards,
Keith.
www.keithwilby.com