Set an SQLQuery...Try this: SELECT Max(unique id) FROM table_name -- "Max" finds the highest id in the database but if your system have the ability to accept multiple inputs at the same time maybe you should add a WHERE in this select statement(let's say WHERE name= & strFullName
Then execute query. Good luck! On Thu, 03 Mar 2005 23:41:44 -0000, dcase14 <[EMAIL PROTECTED]> wrote: > > Good morning everybody > > I'm attempting to add records to an access database from an ASP form. > Unfortunately, the database was designed by someone else and doesn't > have an autonumber unique id. Can anybody tell me how to find out the > last record and add a new one so it doesn't over-write an existing record? > > The pseudo-code is something like: > > 1 Set Connection > 2 Execute SQL > 3 Set RecordSet > 4 Define variables for each table field > 5 Assign a unique ID to the new record <-- this is the problem > 6 Post data to new page with updates the database > > The way I see it, the solution will be to identify the maximum number > of the id field and + 1. I just can't find out anywhere how to do this. > > Thanks in Advance > nick > > > > > Yahoo! Groups Sponsor > ADVERTISEMENT > > ________________________________ > Yahoo! Groups Links > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
