Access 2007 and Environ() Workaround for table default Value 1

[ToyFox]

I have to migrate a few databases over to 2007.
They were built with Environ("UserName") set in the default value of each table. This command is not supported in 2007, there is fOSUserName() which works fine, but NOT in the table default value. Is there anything I can use in place of Environ() in the table default value.

 

[dhookom]

Don't allow any data entry into tables. In your forms or code you can use fOSUserName() as a default.

Duane
Hook'D on Access
MS Access MVP