Table-Level Validation Error Message

K

Karen

Hi,

I have an Access 2003 app that has a .mde front-end and .mdb back-end. The
app is distributed with the runtime as several potential users do not have
Access. When I run the .mde on my development machine in runtime mode
everything is fine. Specifically I have some tables that default datetime
field values of either Date() or Time().

I also have a 'clean' machine on which I test the install. The 'clean'
machine is XP Pro with only Word installed. I use Norton Ghost to reload
the 'clean' environment for each test.

The install is fine but there are two forms that open with fields which
should have the Date() and/or Time() automatically filled in, on the 'clean'
machine, yet I get an error message 'Function is not available in
expressions in table-level validation expression'. The fields have the
'#Name' expression instead of the date.

I do not table-level validation anywhere in the app.

I've done an internet search on the error and can't find anything that may
explain the problem.

Any help would be very much appreciated.
 
Top