Vista ODBC Date Error after migrating from Windows XP to Vista

Vista ODBC Date Error after migrating from Windows XP to Vista

Post by cross » Sun, 04 Jan 2009 03:00:55


After migrating a working Access 2003 front-end with ODBC links to a
Sql Server 2005 back-end db from Windows XP to Vista, I can no longer
filter any date or even use them in queries to filter. In Access, when
I try to filter any date (just by clicking on the the Filter By
Selection button) I get the error message, "Microsoft Access has
stopped working" and it closes the db down. The same database works
fine using Windows XP, I can filter the dates without any problems.
The filter works for all other data types on both operating systems. I
have installed all the latest updates for Vista and Office. Any other
suggestions? Thanks.
 
 
 

Vista ODBC Date Error after migrating from Windows XP to Vista

Post by David W. F » Sun, 04 Jan 2009 11:27:53


XXXX@XXXXX.COM wrote in

m:


Have you tried deleting all the linked tables and recreating them on
Vista?

--
David W. Fenton http://www.yqcomputer.com/
usenet at dfenton dot com http://www.yqcomputer.com/

 
 
 

Vista ODBC Date Error after migrating from Windows XP to Vista

Post by Q3Jvc3N » Sat, 17 Jan 2009 23:42:01

FYI, I decompiled then compiled all Access 2003 databases in my Windows XP
machine and now everything works fine on the Vista machines.