Function is not available in...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all
I am getting the following bizarre error message on one of our databases:
'Function is not available in expressions in table-level validation epression'

The database has not been split and works absoloutely fine on my machine but
when it is run from another users machine this message occurs when they try
and do stuff. All of our machines should be the same as they are installed
from the same image. They run Win XP Pro and Access 2002.

I traced it back to one of the tables where I have made the default value
'Date()'. If I change this to a constant value eg '08/04/2005' then it is
fine. However if I then change it back to 'Date()' when I try and save the
table I get the error message again.

Thanks in advance for any help...

Andy
 
You probably have a missing reference on the other PC. Open any code module
and look at Tools|References while on that PC....note any references that
are listed as MISSING. Determine whether or not the reference is actually
needed...i.e., remove it and try to compile your app. If it is indeed
needed, you may need to include it as part of your installer or consider
another option like late binding.
 
Thanks for getting back to me Paul

I wondered if that might have been the case and had checked for Missing
references but they seem to be ok.
 
Hmmm...in that case, I'd try importing everything to a new mdb and see if
you still get the same message.
 
That seems to have done the trick - thanks very much Paul - any ideas on what
would cause this or is it just that the original file became corrupt?

Andy
 
Yes, it would appear there was some corruption...although it apparently
wasn't discovered by Jet.
 
Back
Top