Hi, If anyone can help with this problem I would much appreciate it. I have a site working with Snitz and with some other ASP applications. I have two MS Access 2000 databases which are very similar, and use the similar connection strings etc. The problem is that on one of these databases my SQL queries do not return the correct records. There are two examples.... Select TOP 10 etc Select * from table where fielddate > (date - 15) In case 1 the records are not being limited to 10. In case 2 the date compare is not working. The weird thing is that in the other application, the identical SQL does work.
if the connstring's are the same, then I dont know what could be the problem. But if your using different Jet drivers, you may consider changing the connection string for the one that does not work, to the same as the one that does work (except database path of course)
Topic Locked
Posted - 22 March 2001 : 07:28:58
