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?
 
PatHartmanConnect With a Mentor Commented:
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 BrockConnect With a Mentor CIOCommented:
Yes.

/gustav
0
All Courses

From novice to tech pro — start learning today.