BullZip Home

autonumber in MySql and MS Access tables. I found one solution for autonumber fields. The trick is to NOT use the autonumber field in the PRIMARY key and to add a record save command to the after-update event property of a field on the form. I placed this on the first data entry field. You can use t...

First, the MS Access to MySql program is impressive. I was up and running in under five minutes! I converted a small database that uses a autocounter field as the primary key. After entering the record, all fields change to #Deleted. Closing and reopening the table works OK. I've read a little about...