CODEWITHSUNDEEP
ms-accessms-access-2007
Andrew Shepherd
Andrew Shepherd

Reputation: 45252

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

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?

Upvotes: 1

Views: 7271

Answers (1)

DJ.
DJ.

Reputation: 16247

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.

Upvotes: 1

Related Questions