I am on migration from MS Access 2007 to SQL Server 2012 express. Recently I am faced with strange Access frontend behavor.
In one of our Apps based on MS Access I simulate Excel style to enter Employee working hours data on continuous form. On Open event subroutine prepares recordset for this form. In Soubroutine I have three MakeTable queries where I pass four parameters to each of them. All queries are based on Crosstab queries accordingly. I have saved all queries so I call them in subroutine by names (set querydef and pass all parameters).
But may problem is not actually related to Subroutine:
All MakeTable queries executes without error. However, only first table has records. Other two are empty.
- If I pass parameters manualy to each Crosstab query I see records in all three of them.
- If I pass parameters manualy to each MakeTable query I see records only in first made Table. Two others are empty!
And most interesting is that it appiers only with SQL Server BackEnd. If I do all steps with MS Access BackEnd all works just fine!
In one of our Apps based on MS Access I simulate Excel style to enter Employee working hours data on continuous form. On Open event subroutine prepares recordset for this form. In Soubroutine I have three MakeTable queries where I pass four parameters to each of them. All queries are based on Crosstab queries accordingly. I have saved all queries so I call them in subroutine by names (set querydef and pass all parameters).
But may problem is not actually related to Subroutine:
All MakeTable queries executes without error. However, only first table has records. Other two are empty.
- If I pass parameters manualy to each Crosstab query I see records in all three of them.
- If I pass parameters manualy to each MakeTable query I see records only in first made Table. Two others are empty!
And most interesting is that it appiers only with SQL Server BackEnd. If I do all steps with MS Access BackEnd all works just fine!