This is probably out there somewhere but with the search functionality not working it makes it a little difficult. 
I have a form in MS Access that is being populated by a stored procedure which is passing two parameters to the database. One is smalldatetime (@EnterCheckDate), the other is int (@EnterEmpNo).
That main form works great.
Now I need to add a subform that is gathering data from a view in SQL Server. I link it to EmpNo (@EnterEmpNo) and that works fine but the data needs to be narrowed down some, so I try to link it by CheckDate (@EnterCheckDate) and I get the error that I am trying to link fields with incompatible data types. I tried removing the link for the CheckDate and used pay_check number (which is a better solution anyway) and I still got the same thing. AUGH!
I have verified that my joins in the sprocs and view are using the same data types. I have also made sure that my parameter values match how the fields are defined in the tables as well. Everything checks out.
I do not know what else to check.
I have a form in MS Access that is being populated by a stored procedure which is passing two parameters to the database. One is smalldatetime (@EnterCheckDate), the other is int (@EnterEmpNo).
That main form works great.
Now I need to add a subform that is gathering data from a view in SQL Server. I link it to EmpNo (@EnterEmpNo) and that works fine but the data needs to be narrowed down some, so I try to link it by CheckDate (@EnterCheckDate) and I get the error that I am trying to link fields with incompatible data types. I tried removing the link for the CheckDate and used pay_check number (which is a better solution anyway) and I still got the same thing. AUGH!
I have verified that my joins in the sprocs and view are using the same data types. I have also made sure that my parameter values match how the fields are defined in the tables as well. Everything checks out.
I do not know what else to check.
