User Logins and passwords and Notes History

[Matuag]

Hi All,

Is there anyway we can create different Usernames, user levels and
passwords in Access 2007? I could not find any icons for this on the
ribbon.

I have created Notes History using
=ColumnHistory([RecordSource],"Notes","[ID]=" & Nz([ID],0))

which returns
[Version: 18/05/2007 1:03:26 PM ] This is a test note2
[Version: 18/05/2007 1:03:16 PM ] This is a test note1
[Version: 18/05/2007 1:02:56 PM ] Testing

Is it possible to add 'Useraame' instead of 'Version' in notes
history?
Cheers, Matuag

[Tom van Stiphout]

On 18 May 2007 13:09:58 -0700, Matuag <ma****@gmail.c omwrote:

Required reading for developers curious about A2007 security:
http://msdn2.microsoft.com/en-us/library/bb421308.aspx

Personally if I don't need serious security but still want user
groups, I'd use Active Directory.

-Tom.

>Hi All,

Is there anyway we can create different Usernames, user levels and
passwords in Access 2007? I could not find any icons for this on the
ribbon.

I have created Notes History using
=ColumnHistory ([RecordSource],"Notes","[ID]=" & Nz([ID],0))

which returns
[Version: 18/05/2007 1:03:26 PM ] This is a test note2
[Version: 18/05/2007 1:03:16 PM ] This is a test note1
[Version: 18/05/2007 1:02:56 PM ] Testing

Is it possible to add 'Useraame' instead of 'Version' in notes
history?
Cheers, Matuag

[Matuag]

Hi Tom,

I can't find 'Users and Group Permissions' on 'Database Tools' tab.
Also where is 'Active Directory'? :(

I am using Access 2007 Enterprise.

Cheers, Matuag
,

[Jens Schilling]

Hi,

I can't find 'Users and Group Permissions' on 'Database Tools' tab.

It's removed in A2007 - read more about it here :

http://blogs.msdn.com/access/archive...19/482845.aspx

Also where is 'Active Directory'? :(

And a introduction to Active Directory you can find here :

http://technet2.microsoft.com/window....mspx?mfr=true

Regards
Jens

[Tom van Stiphout]

On 20 May 2007 08:40:01 -0700, Matuag <ma****@gmail.c omwrote:

Active Directory is a kind of database on the Primary Domain
Controller of Windows networks. Among other things it stores the list
of users and their permissions. You can create groups, and put users
in those groups. Then from Access or any other tool you can query
active directory and ask "is user X a member of group Y", and based on
the answer grant or deny access to certain features.

-Tom.

>Hi Tom,

I can't find 'Users and Group Permissions' on 'Database Tools' tab.
Also where is 'Active Directory'? :(

I am using Access 2007 Enterprise.

Cheers, Matuag
,

[David W. Fenton]

Tom van Stiphout <no************ *@cox.netwrote in
news:lr******** *************** *********@4ax.c om:

Personally if I don't need serious security but still want user
groups, I'd use Active Directory.

Do you have code already written for that? I have the documentation
for proof-of-concept but have never implemented it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Tom van Stiphout]

On Sun, 20 May 2007 12:11:29 -0500, "David W. Fenton"
<XX*******@dfen ton.com.invalid wrote:

Here is some source code:
http://msdn2.microsoft.com/en-us/library/aa772126.aspx

-Tom.

>Tom van Stiphout <no************ *@cox.netwrote in
news:lr******* *************** **********@4ax. com:

>Personally if I don't need serious security but still want user
groups, I'd use Active Directory.

Do you have code already written for that? I have the documentation
for proof-of-concept but have never implemented it.

[Matuag]

Its pity I can't use user and groups in access 07. Active Directory is
little tough for me to understand.

Thank you all anyway.

[Jens Schilling]

Hi,

Its pity I can't use user and groups in access 07. Active Directory is
little tough for me to understand.

An other solution might be the recommended practice - to move your data to a
centralized service like SQL Server or MSDE.

Regards
Jens

[David W. Fenton]

Tom van Stiphout <no************ *@cox.netwrote in
news:hc******** *************** *********@4ax.c om:

On Sun, 20 May 2007 12:11:29 -0500, "David W. Fenton"
<XX*******@dfe nton.com.invali dwrote:

Here is some source code:
http://msdn2.microsoft.com/en-us/library/aa772126.aspx

That's pretty much the equivalent of the code I already had.

I find it interesting that MS ignores all their classic VB
developers and uses VBScript and VB.NET for their examples. *sigh*

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/