<div>
Are you passing any variables that work with the SQL variable? &nbsp;It sounds like you have a variable declaration that is INT and you are now attempting to assign a BIGINT.<br />
<br />
It could also be the actual SQL query with joins that is causing the issue. &nbsp;I would recommend taking a look at the query that is being used by the SQL variable.<br />
<br />
Tom
</div>


Are you passing any variables that work with the SQL variable?  It sounds like you have a variable declaration that is INT and you are now attempting to assign a BIGINT.

It could also be the actual SQL query with joins that is causing the issue.  I would recommend taking a look at the query that is being used by the SQL variable.

Tom

<div>
Hi Tom,<br />
The code was working until I removed the autonumber and changed int to bigint on the Key field. <br />
<br />
I had a look at the table in access and just get lots of #Deleted, I tried changing from bigint to int then relinked the table and still got lots of #Deleted
</div>


Hi Tom,
The code was working until I removed the autonumber and changed int to bigint on the Key field.

I had a look at the table in access and just get lots of #Deleted, I tried changing from bigint to int then relinked the table and still got lots of #Deleted

<div>
OK I'm sorted.<br />
<br />
I restored the database, removed the Autonumber without changing the datatype and it is now OK.
</div>


OK I'm sorted.

I restored the database, removed the Autonumber without changing the datatype and it is now OK.

<div>
Change back to int sorted it
</div>


<div>
<div class="content wysiwyg-content">
I changed an autonumber (int) to bigint<br />
<br />
I now get an error on this line: -<br />
Set Rst = Dbs.OpenRecordset(Sql, dbOpenDynaset, dbSeeChanges)<br />
<br />
&quot;Data type missmatch&quot;<br />
<br />
Does anyone know how to solve?
</div>
</div>


I changed an autonumber (int) to bigint

I now get an error on this line: -
Set Rst = Dbs.OpenRecordset(Sql, dbOpenDynaset, dbSeeChanges)

"Data type missmatch"

Does anyone know how to solve?

Access error after changing primary key data type

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.