Is there a simple code I can use in order to get a random record from a access database in ASP ? please help me out :)

I don't work in ASP or Access, but this website (http://www.adopenstatic.com/faq/randomrecord.asp) has an example doing exactly what you want.

Next time, please learn how to use a search engine (http://www.google.com/help/basics.html) -- it took me 2 minutes to find this website.

Just for your information... 1 random record... with MySQL...


SELECT * FROM t1 ORDER BY rand() LIMIT 1