How to obtain a number of last record in Database

From: Chris (zajcu4_at_yahoo.com)
Date: 01/21/05 

Date: 21 Jan 2005 06:14:35 -0800

Hello Guys,
I have a problem how to find a number (ID - I use autonumber) of the last record in the database using ADO Connection.
For example.
I insert a new recordset. It creates a new entry in DB with a new
autonumber ID. Then I need to get this ID in order to use it in another table.
Thank you for any help
Chris

Relevant Pages

  • Re: book publishing database--design question about tabbed forms
    ... Building a database is like building a house... ... if you care about that Autonumber then best to ... which my query and tabbed form became essentially read-only--unable to be ... click a desired tab. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Set value of one field depending on result of next record in q
    ... The autonumber issue should not be a problem. ... table" query to deal with the issue that S Clark offered a solution with. ... > See http://www.QBuilt.com for all your database needs. ... >> Michael Bond ...
    (microsoft.public.access.queries)
  • Re: Renumbering records
    ... Autonumber is just a special kind of default value, ... represent the sequence in which the records were added. ... I wanted to maintain that order and I thought the database ... That would be a regular replica, ...
    (microsoft.public.access.replication)
  • Re: Non-unique KeyIDs (Autonumber) in Access 2000
    ... The problem is creted by a database tool we developed to help fix our ... Dim WS As Workspace, DB As Database, TempDB As Database ... it creates an autonumber than is the same as an existing ... >> We have a problem with an Access 2000 table where the KeyID field was ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Simple between and query
    ... What I figured out on my own was to created the ID as an autonumber. ... school database Students and Courses need to be in separate tables. ... hide original message or reply text. ... Phonebook table and a FaxNumber: ...
    (microsoft.public.access.queries)