I have an Access database, and a website (dev only at this time) and I'm getting a parculiar problem and wondered if anyone else has come across it.
I have a query that hits the database and should return the records in a randomised fashion. If I run the query from the database it works, but the records always come back in the same order from the website. If I write the sql to the page and run it in Access the records do ranomise so ithe SQL generated from the page is working. I have placed every bit of 'do not cache' code I can find in the page, and the connection is set to nothing and closed every time.
I have tried different cursors all to no avail.
Can anyone offer and help.