Steve: do you mean insert a value into an autonumber field?
if so, Sure. the trick is that the number HAS to be unique. a quick example table: tTest ==================== id: autonumber testValue: text throw this in as a query INSERT INTO tTest ( id, testValue ) VALUES ([EMAIL PROTECTED], [EMAIL PROTECTED]); add appropiate values cheers barry.b PS: it's "damn" - dam is what the Franklin River almost was. -----Original Message----- From: Steve Onnis [mailto:[EMAIL PROTECTED] Sent: Friday, 13 June 2003 6:16 PM To: CFAussie Mailing List Subject: [cfaussie] Dam Access Can you do an IDENTITY INSERT on an Access Database? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
