Invalid Precision Value - Date

[jrbade]

I am using MS Access 2007 to load financial & manufacturing data into Sage PFW database that uses Pervasive 9.11.063. It was working fine until late last year when every update or append query failed with the Invalid Precision Value error. Remove the date, and query runs fine. The server has a copy of Access 2003 which also now has the same problem.

I am now at the point where I am ready to load payables and receivables that must have date information loaded and I need to resolve this problem. This seems to be the same problem as thread318-1453933 for which there was no particular resolution.

Can anyone help please?

 

[Remou]

Have you tried formatting to short date?

 

[jrbade]

Long date, short date, general date - makes no difference.