Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table ID

Status
Not open for further replies.
CookieNZ

CookieNZ

MIS
Apr 22, 2002
48
NZ
When connecting to an Access 2000 db using the oledbadapter from vb.net, is it possible to read the ID of the last record in the database.

What I trying to do is use a sql script to insert a new record, but can not insert since I do not know the ID to insert the new record to.
 
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
345
Andrzejek
Andrzejek
StevenFromSouth
  • Locked
  • Question
Delete record from one table if it does not exist in another 1
Replies
15
Views
502
Andrzejek
Andrzejek
MaMike
  • Locked
  • Question
Access form -> another form against the same table not going to the right record
Replies
2
Views
227
MaMike
MaMike
nikademous
  • Locked
  • Question
Fill text boxes with table data 1
Replies
12
Views
445
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top