Following Odbc-Access manuals, you should use:
select @@identity
with no table name. this value is the last value of the last modified
recordset on that database.
Mike
www.ibcmass.com
mailto:[EMAIL PROTECTED]
> -----Mensaje original-----
> De: Jonathan R. Karlen [mailto:[EMAIL PROTECTED]]
> Enviado el: jueves 3 de agosto de 2000 16:14
> Para: [EMAIL PROTECTED]
> Asunto: Access AutoiNumber Fields
>
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0004_01BFFD33.9974EEC0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> How do you get the value used by Access in an AutoNumber field. For
> example, you insert a record into one table and then, within the same
> template, need to use the ID assigned to that record.
>
>
>
> ***************************************
> Jonathan R. Karlen
> Karlen Internet Solutions
> Web Site and Application Development
> [EMAIL PROTECTED]
> http://www.karlen.com
>
>
> ------=_NextPart_000_0004_01BFFD33.9974EEC0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
> xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40">
>
> <head>
> <meta http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <meta name=3DProgId content=3DWord.Document>
> <meta name=3DGenerator content=3D"Microsoft Word 9">
> <meta name=3DOriginator content=3D"Microsoft Word 9">
> <link rel=3DFile-List href=3D"cid:[EMAIL PROTECTED]">
> <!--[if gte mso 9]><xml>
> <o:OfficeDocumentSettings>
> <o:DoNotRelyOnCSS/>
> </o:OfficeDocumentSettings>
> </xml><![endif]--><!--[if gte mso 9]><xml>
> <w:WordDocument>
> <w:View>Normal</w:View>
> <w:Zoom>0</w:Zoom>
> <w:DocumentKind>DocumentEmail</w:DocumentKind>
> <w:EnvelopeVis/>
> </w:WordDocument>
> </xml><![endif]-->
> <style>
> <!--
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
> {mso-style-parent:"";
> margin:0in;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:Arial;
> mso-fareast-font-family:"Times New Roman";
> mso-bidi-font-family:"Times New Roman";}
> p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
> {margin:0in;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:Arial;
> mso-fareast-font-family:"Times New Roman";
> mso-bidi-font-family:"Times New Roman";}
> span.EmailStyle15
> {mso-style-type:personal-compose;
> mso-ansi-font-size:10.0pt;
> mso-ascii-font-family:Arial;
> mso-hansi-font-family:Arial;
> mso-bidi-font-family:Arial;
> color:black;}
> @page Section1
> {size:8.5in 11.0in;
> margin:1.0in 1.25in 1.0in 1.25in;
> mso-header-margin:.5in;
> mso-footer-margin:.5in;
> mso-paper-source:0;}
> div.Section1
> {page:Section1;}
> -->
> </style>
> </head>
>
> <body lang=3DEN-US style=3D'tab-interval:.5in'>
>
> <div class=3DSection1>
>
> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> color=3Dblack
> face=3DArial><span =
> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>How do you
> get the value used by Access in an AutoNumber field.<span =
> style=3D"mso-spacerun:
> yes"> </span>For example, you insert a record into one
> table and =
> then,
> within the same template, need to use the ID assigned to that =
> record.<o:p></o:p></span></font></span></p>
>
> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> color=3Dblack
> face=3DArial><span =
> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font><
> /span></p>
>
> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> color=3Dblack
> face=3DArial><span =
> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font><
> /span></p>
>
> <p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
> color=3Dblack
> face=3DArial><span =
> style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font><
> /span></p>
>
> <p class=3DMsoAutoSig><!--[if supportFields]><font
> color=3Dblack><span=20
> style=3D'color:black'><span =
> style=3D'mso-element:field-begin'></span><span=20
> style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s
> "E-mail=20
> Signature" <span =
> style=3D'mso-element:field-separator'></span></span></font><![
> endif]--><f=
> ont
> color=3Dblack><span =
> style=3D'color:black'>***************************************<
> /span></fon=
> t><font
> color=3Dblack><span =
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> face=3DArial><span =
> style=3D'font-size:
> 12.0pt;color:black'>Jonathan R. Karlen</span></font><font =
> color=3Dblack><span
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> face=3DArial><span =
> style=3D'font-size:
> 12.0pt;color:black'>Karlen Internet Solutions</span></font><font =
> color=3Dblack><span
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> face=3DArial><span =
> style=3D'font-size:
> 12.0pt;color:black'>Web Site and Application =
> Development</span></font><font
> color=3Dblack><span =
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> face=3DArial><span =
> style=3D'font-size:
> 12.0pt;color:black'>[EMAIL PROTECTED]</span></font><font =
> color=3Dblack><span
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> <p class=3DMsoAutoSig><font size=3D3 color=3Dblack
> face=3DArial><span =
> style=3D'font-size:
> 12.0pt;color:black'>http://www.karlen.com</span></font><font =
> color=3Dblack><span
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> <p class=3DMsoNormal><!--[if supportFields]><font
> color=3Dblack><span=20
> style=3D'color:black'><span =
> style=3D'mso-element:field-end'></span></span></font><![endif]--><font
> color=3Dblack><span style=3D'color:black'><![if =
> !supportEmptyParas]> <![endif]></span></font><font
> color=3Dblack><span =
> style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></sp
> an></font><=
> /p>
>
> </div>
>
> </body>
>
> </html>
>
> ------=_NextPart_000_0004_01BFFD33.9974EEC0--
>
> --------------------------------------------------------------
> ----------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
