Joe Bleicher
New Member
- Joined
- Mar 9, 2010
- Messages
- 2
Access 2007 I added a field to a table and went to save and received the following error
"Compile error. in table-level validation expression."
On investigation found I had a date field that had Default property set to Now().
Removing the default allowed me to save the table.
I have been using this technique for years. And for the last 5 months with Access 2007.
(Note I am working in an enterprise environment.)
Two weeks ago the same problem manifested but started to work again after about a half hour.
Today it’s going on 8 hours of trying to figure this out but no joy searching the internet.
I am assuming that the network admin is doing something that is causing this problem.
What ever they are doing with some security setting is not allowing VBA functions to compile.
I tried to make a user certificate and apply to application, no joy.
Any help with this problem would be greatly appreciated.
Regards, Joe
"Compile error. in table-level validation expression."
On investigation found I had a date field that had Default property set to Now().
Removing the default allowed me to save the table.
I have been using this technique for years. And for the last 5 months with Access 2007.
(Note I am working in an enterprise environment.)
Two weeks ago the same problem manifested but started to work again after about a half hour.
Today it’s going on 8 hours of trying to figure this out but no joy searching the internet.
I am assuming that the network admin is doing something that is causing this problem.
What ever they are doing with some security setting is not allowing VBA functions to compile.
I tried to make a user certificate and apply to application, no joy.
Any help with this problem would be greatly appreciated.
Regards, Joe