Hi Folks
Bit of a weird one this. I've got two access databases same version of access, exactly the same structure (just store info for two websites)
I go into one and do a simple query and I get back the expected results. Go into the other copy, and paste the exact same sql statement and I either get a "data type mismatch" error or a "driver may be out of resources" error
Been driving me mad for days.
Anyone got any ideas?
As i say it's just a simple query:
SELECT Order.* FROM [Order] WHERE (((DateValue([Date Ordered]))>#01/01/09#))
Thanks
Bit of a weird one this. I've got two access databases same version of access, exactly the same structure (just store info for two websites)
I go into one and do a simple query and I get back the expected results. Go into the other copy, and paste the exact same sql statement and I either get a "data type mismatch" error or a "driver may be out of resources" error
Been driving me mad for days.
Anyone got any ideas?
As i say it's just a simple query:
SELECT Order.* FROM [Order] WHERE (((DateValue([Date Ordered]))>#01/01/09#))
Thanks