I have an app that I'm re-writing for MySql and MsSql, the old version
connected to an Access database. It is more than likely that existing
customers will want to upgrade to the later version. I don't want to rely
on 3rd party apps for Migration, so.... I'm more than happy to write the
connection code and transfer the data myself, but I don't know how to ensure
that all Auto Number fields in the Access database transfer correctly, as in
SQL a counter field cannot be written. The Access database will probably
not start at 1 for all Auto Number fields, there may also be missing numbers
in the Auto Number fields as records will have been deleted. Can anyone
help?