automatic index changes

[MissiMaths]

Hi, I was wondering if you could help me with something. I have a
table in access that I have placed an autonumber index on to run in
ascending order. Data is entered onto the table through a number of
forms and using DAO. My problem is that every so often the index
decides itself to reverse to descending order. As I use a move last to
reference the appropriate part of the table for data entry, this can
cause no end of problems. I was hoping someone could tell me why this
happens, or how it happens or how I can prevent it from ever happening
again????

Thanks in advance

[Rog]

A table in Access has no instrinsic order. Base your form on a sorted
query, and use "order by" in your sql string to sort your dao
recordset.

MissiMaths wrote:

Hi, I was wondering if you could help me with something. I have a
table in access that I have placed an autonumber index on to run in
ascending order. Data is entered onto the table through a number of
forms and using DAO. My problem is that every so often the index
decides itself to reverse to descending order. As I use a move last to reference the appropriate part of the table for data entry, this can
cause no end of problems. I was hoping someone could tell me why this
happens, or how it happens or how I can prevent it from ever happening again????

Thanks in advance

[Tony Toews]

mi********@hotmail.com (MissiMaths) wrote:

Hi, I was wondering if you could help me with something. I have a
table in access that I have placed an autonumber index on to run in
ascending order. Data is entered onto the table through a number of
forms and using DAO. My problem is that every so often the index
decides itself to reverse to descending order. As I use a move last to
reference the appropriate part of the table for data entry, this can
cause no end of problems. I was hoping someone could tell me why this
happens, or how it happens or how I can prevent it from ever happening
again????

There is a bug in an older version of Jet Service Pack which had this problem. Is
every computer running a recent version of Jet? Preferably Jet 4.0 SP 8 or newer.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the Verify Appropriate Jet Service Pack is installed page at my
website for more details including sample code:
www.granite.ab.ca\access\verifyjetsp.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm