Web Development

Ask something
Discussion Locked

Data gets scrambled

0 helpful
3 replies

by lwwilliams

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When a database that I created is closed and reopened the autonumber/text (letters and numbers are used in the text) column is scrambled. Do you have any idea why that happens?

3 replies

by lwwilliams

I'm adding a little more detail to this one. Example: Numbers are (2234,2235,2236,2237) before database is closed. When database is reopened the numbers may be scrambled like this(2235,2237,2236,2234). In other words the numbers do not come back up in order (like this 2234,2235,2236,2237).

by shellbot

Any more info?
-what Db?
-how are you opening it?
-I presume you mean you are opening a Database Table?
...if so..maybe there is particular index or property that is affecting it?

by lwwilliams

Any more info?
-what Db? It is a db used to input rework info on a (form).
-how are you opening it? We open it from the desktop.
-I presume you mean you are opening a Database Table? I have it setup so that when the db is opened the rework input (form) opens automatically.
Thanks.

This discussion is closed to new replies.