MySQL Forums
Forum List  »  Microsoft Access

Primary Key (AutoInc) is set after storing the record
Posted by: Georg Linde
Date: February 28, 2010 03:41PM

Hi,
I migrated the tables of an Access-Database to MySQL. All other objects are still in the access-file as a frontend-application. Works nearly well.

I have one problem: In the former-Access version, the Primary Key-field (AutoInc) of a specific table was set during filling the record with data (before saving the record). In MySQL (I'm using InnoDB-Engine), this field is set after saving.

I need to retrieve this AutoInc-value of the specific record via VBA after I stored some data in this record (also via VBA).

Any idea ? Or is there a possibility to set up MySQL so that the AutoInc-field gets the value before saving ?

Thanks,
Georg

Options: ReplyQuote


Subject
Views
Written By
Posted
Primary Key (AutoInc) is set after storing the record
3222
February 28, 2010 03:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.