- How to get the auto increment primary key in old mdb database?
- Dim db As Database 'Test Database
- Dim rs As Recordset 'Test Table
- ...
- rs.AddNew
- id = rs!id
- Using oConn As New OleDbConnection(m_ConnString)
- oConn.Open()
- Using cmd As New OleDbCommand(sqlInsert, oConn)
- cmd.ExecuteNonQuery()
- End Using
- End Using