In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> I have a table that I need to update using "INSERT INTO table (field1,
> field2) VALUES (val1, val2)" The table has an AutoNumber field for a Primary
> Key called "ID". I need to get the ID that was assigned in the INSERT.
> With PostgreSQL you do this with oids but as far as I know Access doesn't
> use them. How then can I do this?
Well, since you insist on using Access for a web database...
Here's one way...
Make sure you are tracking sessions, Create a session field in the Access
table. After the instr, select the max(recordID) for the table with the
current session number.
Many here would recommend that you convert to mySQL and drop Access...
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]