I am developing a toll free number management utility for a customer. This customer specifically wants the tfn(toll free number) field to be numeric. They want the field to be numeric in order to sort the field in datasheet view within an msaccess app.
According to http://www.w3schools.com/sql/sql_datatypes.asp
mysql stores unsigned int 0 to 4294967295 these tfn's are 8881231234 and larger.
I cant use the bigint datatype because access doesn't handle bigint. I have tried changing the fields to bigint but access returns #DELETED for all records.
Please help with how to solve storing this tfn number in a mysql table but still able to be sorted numerically within an access db in datasheet view?