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 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/
