[Rhodan]

I've been bashing my head against the wall trying to figure out why I couldn't use recordcount and absoluteposition with VB6 ADO on the variables table and I've finally figured it out.

TIMESTAMPS!

A few of the variables have 0000... for a timestamp which somehow breaks mysql's ability to provide all the information requested, or maybe its ADO not being able to handle the bad timestamp... or something.

I was just experimenting with (a copy of) the variables table, removing items one by one until the ADO stuff would work. It took a few tries before I noticed the timestamp trend in the failures (doesn't help that the window had all but the first two timestamp digits hidden lol!

Anyway, I threw in real timestamps and all of a sudden all my ADO stuff has come to life. Hopefully anyone else having this problem in the future will score a hit on this post and be saved the hassle and headaches.