Hello MS Access Expert,
I am experiencing different query results when linked to SQL Server Tables, specifically, when I hard code criteria vs. a Form Reference. Note I don't experience this discrepancy when using Local MS Access Tables. I have attached the example database as a Zip.
I have now also added a video demonstrating the issue.
Thank you for your assistance and explanation for this inconsistent behavior.
1) Open the Database and Open frmA
2) Run qryCorrect and qryCorrectNOT which return the same Results because they are currently querying the local tables.
3) Migrate dbo_tblAccess and dbo_tblBAccess to SQL Server.
4) Run qryCorrect and qryCorrectNOT on the SQL Server Tables. You will now notice the Results are no longer the same.
SQL Server Incorrect Answer
Local Tables Correct Answer
I am experiencing different query results when linked to SQL Server Tables, specifically, when I hard code criteria vs. a Form Reference. Note I don't experience this discrepancy when using Local MS Access Tables. I have attached the example database as a Zip.
I have now also added a video demonstrating the issue.
Thank you for your assistance and explanation for this inconsistent behavior.
1) Open the Database and Open frmA
2) Run qryCorrect and qryCorrectNOT which return the same Results because they are currently querying the local tables.
3) Migrate dbo_tblAccess and dbo_tblBAccess to SQL Server.
4) Run qryCorrect and qryCorrectNOT on the SQL Server Tables. You will now notice the Results are no longer the same.
SQL Server Incorrect Answer
Local Tables Correct Answer
Attachments
Last edited: