INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Invalid Precision Value For Dates in Update Queries

Invalid Precision Value For Dates in Update Queries

(OP)
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?

RE: Invalid Precision Value For Dates in Update Queries

A few questions:
- What happened late last year that changed to cause this behavior?
- Is there anything in the PVSW.LOG?
- Can you run the update query though the PCC and does it return the same value?  
- Are the tables linked in Access or are you using SQL Pass Through Queries?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Invalid Precision Value For Dates in Update Queries

(OP)
Thanks for your assistance.

What happened: For some reason our IT Guy reinstalled Pervasive on our PFW server on 12/17/07. After that I could not run update queries that had any date variable in the query.

Transaction log: Nothing unusual showing except the server reinstall.

The update queries run fine through PCC. I used PCC to create a new test table in the same database. Update query runs fine through PCC but fails through Access.

Access tables are linked. I am not using pass-through although when we correct the query generated by access and run it as a pass-through query it works fine.

The pervasive client ODBC driver version is 9.11.063 matching the client and server side of pervasive.



RE: Invalid Precision Value For Dates in Update Queries

(OP)
I am still trying to find an answer to this problem. I noticed that around the same time the problem occurred, MS-Office SP1 was installed (12/19/07). Might MS be the culprit here?? Any help would be appreciated.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close