Setting a column's default value to be the logged in user name in Access 2007

Question

I have an Access file developed using Access 2003, and am trying to work with it using Access 2007.

Some tables have a "changedby" column, which has a default value of

=Environ("username")

This is triggering an error

Unknown function 'Environ' in validation expression or default value on market.changedby

Is there a replacement function available in Access 2007, which can be used as a formula in a default value for a column?

Answer 1

Check out this thread.

It's states that you have to wrap the environ call in a function to get around the Access "sandbox"

Another poster says you can set the macor security to low to fix it as well.

Answer 2

See Getting all types of Usernames in Access