Re: ADO autInc

From: George Christoforakis (nospam_at_nospam.info)
Date: 12/10/03


Date: Wed, 10 Dec 2003 15:01:20 +0200

Unfortunately you can't. You need to use a query that gets the max+1 from
this specific table.

George Christoforakis.

"Tomas Rutkauskas" <tomasr@mail.lt> wrote in message
news:3fd6fd7d@newsgroups.borland.com...
> Hello,
>
> How to read AutoNumber field value when ADO Dataset become in insert mode?
> I always get null. It seems that AutoNumber is generated after post.
> Is it possible to read Autonumber in insert mode?
>
> p.s. I am using Access 2002, D7. Autonumber is the field in Access db.
>
> Regards,
> Tomas
>
>



Relevant Pages

  • Re: "Indexed or Primary Key cannot contain a Null value" / Autonum
    ... It is bound to a query, but that query only draws from one table. ... or in the AutoNumber field if you open the table in design view? ... I click OK on the error message box, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Dear Microsoft: re: Error 3090...
    ... > When attempting to import a query as a table, ... > "Resultant table not allowed to have more than one AutoNumber field. ... The query you are importing has multiple Autonumber ...
    (microsoft.public.access.queries)
  • Re: Specific "auto numbers" possible?
    ... ineveitably arise when using autonumber. ... Create and run an append query to append the temporary table to the ... New on the Database window toolbar. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Specific "auto numbers" possible?
    ... ineveitably arise when using autonumber. ... Create and run an append query to append the temporary table to ... New on the Database window toolbar. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Specific "auto numbers" possible?
    ... ineveitably arise when using autonumber. ... Create and run an append query to append the temporary table to the ... New on the Database window toolbar. ...
    (microsoft.public.access.tablesdbdesign)