access database data not stored in tested order

[kphite]

I'm not a database expert so forgive the question if it's a stupid one. When I turn on database logging and run my sequence the data isn't always stored in the tables in the same order that it was tested. This is very frustrating when I have multiple loops on a particular parameter. Am I doing something wrong? I realize I could correct the problem by keeping track of the loop dynamically but that's extra work.

kph

[Brian_Beal]

What database are you using.  Access will typically order the records by when they were written.  SQL won't.  The best way to do it is to have a primary key defined.

[kphite]

That's good to know Brian, but I'm using Access. I think this is a TestStand issue. When I get time I'll run an experiment to see if I get it to reproduce consistantly.

kph