ADD USER statement

[RayNDM83]

Hi,
I am new with 2007 access and I read an article about "ADD USER statement"
as well as "ADD GROUP statement". Could someone help me out understand if
this is possible with 2007 access? And if it is, could you give me a
sample/steps of how to create a these two statements?
Thanks for clarifying this matter.
Ray

 

[Arvin Meyer [MVP]]

Those appear to be SQL-Server commands. In Access. Access 2007 does have
User-Level Security when used with the MDB format, but not with the new
accdb format. If using an MDB against SQL-Server, you can use those commands
which are part of the DDL (Data Definition Language) which can be used with
MDB front ends. Some DDL commands can also be used when working with a JET
backend (although not the 2 you mention).

BTW, ADD USER is used to add an existing user to an existing group. There is
no ADD GROUP statement. The correct syntax is CREATE GROUP. You can also:
CREATE USER.

 

[RayNDM83]

I though I could use it with accdb format. I am searching for a way to go
around and create a level of security using the new format. Thank you Arvin.

 

[Arvin Meyer [MVP]]

I'm building my own security using a similar model, but I don't even require
a login. Instead, I get the Windows username from the OS using an API:

http://www.mvps.org/access/api/api0008.htm

and comparing that to a value in a hidden table which also houses security
level so I can use field and row level security. The drawbacks are that it
can be circumvented by a savvy user, who can simply look at the data in the
tables on the server. I just log user activity on the server and can figure
out who's trying to access data directly. I have methods of dealing with
that situation that cannot be made public <g>
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com