By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,066 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,066 IT Pros & Developers. It's quick & easy.

User Logins and passwords and Notes History

P: n/a
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

May 18 '07 #1
Share this Question
Share on Google+
9 Replies


P: n/a
On 18 May 2007 13:09:58 -0700, Matuag <ma****@gmail.comwrote:

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
May 20 '07 #2

P: n/a
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
,

May 20 '07 #3

P: n/a
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
May 20 '07 #4

P: n/a
On 20 May 2007 08:40:01 -0700, Matuag <ma****@gmail.comwrote:

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
,
May 20 '07 #5

P: n/a
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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 20 '07 #6

P: n/a
On Sun, 20 May 2007 12:11:29 -0500, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:

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.
May 20 '07 #7

P: n/a
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.

May 21 '07 #8

P: n/a
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
May 21 '07 #9

P: n/a
Tom van Stiphout <no*************@cox.netwrote in
news:hc********************************@4ax.com:
On Sun, 20 May 2007 12:11:29 -0500, "David W. Fenton"
<XX*******@dfenton.com.invalidwrote:

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/
May 21 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.