I need help with Access

elbekko · 2008-05-26 19:26:42

Let me just start with: Access sucks arse, and so does VB.

Now then, to the problem. I have to get a random row from a table in VB using an Access database. When testing out this simple query in Access (by using the query editor and pressing run), it works fine:

SELECT TOP 1 *
FROM woorden
WHERE woordid NOT IN( 0, 2, 58 )
ORDER BY RND(woordid);

But when I execute it from VB, it always returns the same resultset for some reason.
I tried creating a stored query, and sending whatever is in the IN as a parameter to it, but it still doesn't get a proper new resultset.

I have no idea wtf its problem is, but I'd like a solution that doesn't involve me recreating the whole program (I have to hand it in on thursday).

Any help would be appreciated, since this idiocy is really pissing me off.

Smartys · 2008-05-27 10:54:07

http://www.techonthenet.com/access/func … ic/rnd.php
I think RND works like RAND in MySQL, in that by passing a parameter you're always seeding the random number generator in the same way.

Smartys · 2008-05-27 10:56:51

http://bytes.com/forum/thread198600.html
http://www.dmxzone.com/forum/topic.asp?topic_id=22459

elbekko · 2008-05-27 15:07:54

None of those seem to work. And I think I know why.
Access seems to interpret it all a bit differently than say MySQL. Whatever comes after ORDER BY solely specifies which column to order by and not to order randomly.

I still wonder why it works when you directly execute it in Access, but not in VB.

Forums

#1 2008-05-26 19:26:42

I need help with Access

#2 2008-05-27 10:54:07

Re: I need help with Access

#3 2008-05-27 10:56:51

Re: I need help with Access

#4 2008-05-27 15:07:54

Re: I need help with Access

Board footer