ms access ODBC to mysql

access app connects via odbc to mysql table. Mysql table has an auto increment index field of type BIGINT. Access treats this as a text string and result is all fields show up in access as #Deleted even though the mysql data is fine.

question is what to do to make this field compatible in both ends?
jsgouldAsked:
Who is Participating?
 
PatHartmanCommented:
Access does not yet support BIGINT even though it's been around for years.  Your only option is to change the definition in MySQL if you can.

PS - write to MS to complain.  I have.  Not supporting this particular data type is a real problem.
0
 
jsgouldAuthor Commented:
What should I change mysql to INT I assume it has to be a numeric field to auto-increment.
0
 
Gustav BrockCIOCommented:
Yes.

/gustav
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.