Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 803
  • Last Modified:

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?
0
jsgould
Asked:
jsgould
2 Solutions
 
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now