<div>
What should I change mysql to INT I assume it has to be a numeric field to auto-increment.
</div>


What should I change mysql to INT I assume it has to be a numeric field to auto-increment.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
question is what to do to make this field compatible in both ends?
</div>
</div>


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?

ms access ODBC to mysql

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.