Guid to auto increment

I have a custom module in sugarcrm that I need to change the ID from Guid to auto increment (reason is I am syncing to a MDB file which wont accept the Guid). I done this in phpmyadmin. All works fine and I can export and import in mdb. But for some reason it seems to switch back to guid and import fails. In pic you can see first 3 are correct then it changes to 961??? and then Guid, Steps taken in phpmyadmn - I clicked on Column, ID changed CHAR to INT,Clicked A_I and set options to start from 100. I dont know why it started from 2735 but it was working until it changed back to guid.

guid.png
Pat ShorttManagerAsked:
Who is Participating?
 
ste5anSenior DeveloperCommented:
An Access/Jet database accepts GUID as data type. Either as Jet-native data type Replication ID or as Text.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.