ROWID Or Keyfield Determination

is there a way to get a unique recordnumber for any row in the query?

I wrote a universal access mdb browser in asp and I would like to add a "delete record", but since it is a universal browsr one can not know what the unique keyfield is.
So I need:

1) a way to identify the unique keyfield OR
2) find a way to add a unique record to the query DELETE * in [openedTable] WHERE ????

ROWID is unique for oracle databases. Is there a access-alternative for ROWID?

View Replies

Read Keyfield Value

I have form which displays a customer record and a datagrid of that
customer's orders. I want to read the value of the OrderID (which is the
keyfield), write it to a session variable, redirect to another form where I
read the session variable and display the order detail.
How do I read the OrderID value when the user clicks on a select button in a
particular row of the datagrid?

View Replies

View Related