|
 |
asptoday_discuss thread: UPDATE ACCESS HELP!
Message #1 by "Greg Long" <glong2@c...> on Fri, 18 Jan 2002 04:33:17
|
|
I'm having a problem with updating a Microsoft Access database. My unique
ID numbers within Access have spaces between them. For example...
1, 2, 3, 6, 7, 9, 14, 15, 16. After submitting the form for ID#6, I am
passing the ID number to the update page. As indicated above, #6 is the
4th record in sequence. It is updating ID#9 as if it was the 6th record.
I would like to send you some code if you have time. Let me know.
Message #2 by "asame" <asame00@y...> on Fri, 18 Jan 2002 11:27:28 -0000
|
|
You have deleted some records. Export the structure ONLY of your db to a new
table and repopupalte with your data in the right order. After that,,
instead of deleting, use update.
----- Original Message -----
From: "Greg Long" <glong2@c...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Friday, January 18, 2002 4:33 AM
Subject: [asptoday_discuss] UPDATE ACCESS HELP!
> I'm having a problem with updating a Microsoft Access database. My unique
> ID numbers within Access have spaces between them. For example...
> 1, 2, 3, 6, 7, 9, 14, 15, 16. After submitting the form for ID#6, I am
> passing the ID number to the update page. As indicated above, #6 is the
> 4th record in sequence. It is updating ID#9 as if it was the 6th record.
>
> I would like to send you some code if you have time. Let me know.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #3 by "Greg Long" <glong2@c...> on Fri, 18 Jan 2002 17:44:14
|
|
Future deletions will also be allowed to this table via web. The overall
program also relies on the ID number not changing.
> You have deleted some records. Export the structure ONLY of your db to a
new
> table and repopupalte with your data in the right order. After that,,
> instead of deleting, use update.
>
> ----- Original Message -----
> From: "Greg Long" <glong2@c...>
> To: "ASPToday Discuss" <asptoday_discuss@p...>
> Sent: Friday, January 18, 2002 4:33 AM
> Subject: [asptoday_discuss] UPDATE ACCESS HELP!
>
>
> > I'm having a problem with updating a Microsoft Access database. My
unique
> > ID numbers within Access have spaces between them. For example...
> > 1, 2, 3, 6, 7, 9, 14, 15, 16. After submitting the form for ID#6, I am
> > passing the ID number to the update page. As indicated above, #6 is the
> > 4th record in sequence. It is updating ID#9 as if it was the 6th
record.
> >
> > I would like to send you some code if you have time. Let me know.
>
>
>
> _________________________________________________________
>
> Do You Yahoo!?
>
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
>
Message #4 by "Greg Jennings" <greg.jennings@t...> on Fri, 18 Jan 2002 17:50:30
|
|
I think you must be confusing the concept of a record number and an ID
number. The ID number should be a field in the database that does not
change. However, the record number (for a particular record) certainly
will change when other records are added or deleted.
Is this "ID number" you're talking about a field in the table?
> Future deletions will also be allowed to this table via web. The
overall
> program also relies on the ID number not changing.
>
> > You have deleted some records. Export the structure ONLY of your db to
a
> new
> > table and repopupalte with your data in the right order. After that,,
> > instead of deleting, use update.
> >
> > ----- Original Message -----
> > From: "Greg Long" <glong2@c...>
> > To: "ASPToday Discuss" <asptoday_discuss@p...>
> > Sent: Friday, January 18, 2002 4:33 AM
> > Subject: [asptoday_discuss] UPDATE ACCESS HELP!
> >
> >
> > > I'm having a problem with updating a Microsoft Access database. My
> unique
> > > ID numbers within Access have spaces between them. For example...
> > > 1, 2, 3, 6, 7, 9, 14, 15, 16. After submitting the form for ID#6, I
am
> > > passing the ID number to the update page. As indicated above, #6 is
the
> > > 4th record in sequence. It is updating ID#9 as if it was the 6th
> record.
> > >
> > > I would like to send you some code if you have time. Let me know.
> >
> >
> >
> > _________________________________________________________
> >
> > Do You Yahoo!?
> >
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
> >
|
|
|
View Cart
