Experienced the same problem when moving from sql server 32 bit to sql server 64 bit.

Stored procedures that have run fine as Jet 4.0 also run fine in 64 bit...