Vista OS, Access DB, ODBC Sql Server, Date Error

[crossh]

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. While 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 suggestions? Thanks.

 

[a a r o n _ k e m p f]

maybe you should listen to us and upsize to Access Data Projects

Linked tables are a ****ing nightmare of complexity and performance
problems

 

[Crossh]

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

 

[Howard Burgman]

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