MySQL Forums
Forum List  »  Microsoft Access

Re: Autoincrement fields not recognised as Autonumbers
Posted by: Andrew Dixon
Date: November 24, 2005 04:35AM

I have but it still doesn't work flawless (i.e. the deleted issue still crops up now and again).

Essentially all you need to do is trap the CTRL+V Keypress, in the forms keydown event, parse the clipboard (data is just stored as TAB/CR separated values) and then use code to addnew lines to the required tables.

Incidentally though, the whole problem can be averted if a blank line is inserted, and then data is pasted into the new blank line ~ Not an ideal workaround, but nothing involving the MySQL ODBC Connector seems to be.

Options: ReplyQuote

Written By
Re: Autoincrement fields not recognised as Autonumbers
November 24, 2005 04:35AM

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.