Pervasive ODBC Client Interface Invalid precision value error
Posted on 2004-09-09
I have just started having this problem on some workstations running Access 2k. I have an Access application that uses an ODBC connection (Pervasive SQL 2000) to some customer tables in an Accounting system. There is a Make Table query in Access that creates a temporary table of data from one of the linked ODBC tables. Recently, on some of the workstations whenever this query is executed I get the following error:
[Pervasive][Pervasive ODBC Client Interface] Invalid precision value (#0)
Other workstations in the same environment can run the query without getting the error.
Any ideas or help will be greatly appreciated.