p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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

> > 

> > 

> > 


  Return to Index