Yes I am using Access security and it worked beautifully in my form thank you!
I dont suppose I can use that as a default vlaue in a table can I?
When I tried it it said "Unknown Function"
Could I write a function the default value can call that will return that value?
It wont let me close the table, just says "Unknown Function in default value"
Can I alter the table with SQL (I tried to but cant find the correct syntax)
Or make a new function that will be known that just puts the value in there?
Maybe its because Im using Access 2003?
Function GetUserName()
GetUserName = Environ("UserName")
End Function
Private Sub Form_Open(Cancel As Integer)
Call GetUserName
txtUserName = GetUserName
End Sub
Well, with Pat and Bob in here I don't know if I can add anything to this.... But here is something I use to record a users name.... On this I wanted to know who the user was when a report came to me..... so a function.....
Code:Function GetUserName() GetUserName = Environ("UserName") End Function
Then I might have a field on a form.... eg.. "txtUserName"
and call the function
Code:Private Sub Form_Open(Cancel As Integer) Call GetUserName txtUserName = GetUserName End Sub
See if that might be what your looking for.
Actually, if you use the new ACCDB format, Access Security is no longer available in Access 2007. The only way you can use Access Security in Access 2007 is to stick with the older MDB format.From what I have read I don't think too many are saying good things about Access security in 2007......But maybe some improvements have been made.
Yes, anyone who didn't belong to the appropriate A.D. group would not have rights to the folder and therefore it would generate an error in the frontend when they tried to open it.Can you simply create a group... like "AccessUsers" then place the backend in a file and have that file require the user to belong to "AccessUsers" group. Would this stop the db from functioning if the user did not belong to this group?