Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-20 : 11:02:31
|
Chris writes "Hi,
I've got a silly question, not a huge problem, as I could work around it, but it is slightly annoying.
I've been trying to find an explanation as to why my project, using MSSQL 7 and linked Access 2K forms, inserts records half way through my table. Using the Access form, entering records from the beginning is fine, record autonumbers flow sequentially. But when the form is closed and reopened, and records are addied, in a default view, they may appear half way through the table, rather than the bottom of the table. Autonumbers are still sequential, but it appears if SQL is using a different ID to order the records in a default table view. Surely the "pointer" sould reset to the end of a table on a new entry?
Thanks in advance for any advice,
Chris." |
|
|
|
|
|
|
|
Autonumbers out of sequence (with Access form)