diong wrote:
thanks for the reply..but what i want to know is I will be the who
will input the values of the field "id" in Access 97. For example is
i have a textbox in my ASP Page and my database table in access has 5
records in it. I'll enter a value "12345" in the textbox.. upon
pressing the ok button it will save in the id field and it will
increment 5 times (up to 12349).
thanks!
Think about multi-user activity. If 2 users both simultaneously create a
record using "12345" as the value in that text box, both of their records
will have the same value in the id field. This cannot be what you want. Two
records with the same id?
I cannot think of a good reason for doing something like this. You will
force the data entry process to be serialized, slowing performance. Why do
you care what value is being used in the id field? Why does the value need
to be tied to the number of records existing in the database at the time the
record was created? The only requirement for an id value should be that it
is a unique value.
Please explain your requirements a little better. I suggest you do a little
reading about database design.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"