T
Tom van Stiphout
Forms in ADP can have a stored procedure as the RecordSource. Traditionally
we could write: RecordSource="dbo.EmployeesList" (or use the
RecordSourceQualifier to specify "dbo").
On A2007 runtime this no longer works: The record source 'EmployeeList'
specified on this form or report does not exist.
On A2007 (with or without the /runtime command line switch) it does work.
The only workaround I have found so far is to put the entire expression in
the RecordSource property like this: "exec dbo.EmployeesList". I don't think
this is an intentional change by Microsoft.
Here is why I think this is a bug: SQL Server Profiler is recording: SELECT
* FROM "dbo"."EmployeesList"
Sounds to me like Access is thinking it's a view rather than a sproc.
I have put a backup of the NorthwindCS database and the ADP here:
http://www.kittest.com/NorthwindCS_A2007RT.zip
These files are identical to the ones that shipped with A2000, with the
addition of the EmployeesByID and EmployeesList sprocs, and a few test
buttons on the Main Switchboard. Just like with the original NorthwindCS,
you may have to fix up the database connection before it opens properly.
I know there is a bug in the A2007 runtime. Clint Covington wrote on Jul-20:
"There is a known bug where reports don't work in ADPs. We are working on a
QFE for the issue." That was 2 months ago, and I think the QFE hasn't been
released yet. I'm also not at all sure it will fix this issue, if indeed it
is a bug.
My questions:
* Can you confirm the behavior I am describing?
* Is this a bug?
* Any better workarounds than the one I described above?
we could write: RecordSource="dbo.EmployeesList" (or use the
RecordSourceQualifier to specify "dbo").
On A2007 runtime this no longer works: The record source 'EmployeeList'
specified on this form or report does not exist.
On A2007 (with or without the /runtime command line switch) it does work.
The only workaround I have found so far is to put the entire expression in
the RecordSource property like this: "exec dbo.EmployeesList". I don't think
this is an intentional change by Microsoft.
Here is why I think this is a bug: SQL Server Profiler is recording: SELECT
* FROM "dbo"."EmployeesList"
Sounds to me like Access is thinking it's a view rather than a sproc.
I have put a backup of the NorthwindCS database and the ADP here:
http://www.kittest.com/NorthwindCS_A2007RT.zip
These files are identical to the ones that shipped with A2000, with the
addition of the EmployeesByID and EmployeesList sprocs, and a few test
buttons on the Main Switchboard. Just like with the original NorthwindCS,
you may have to fix up the database connection before it opens properly.
I know there is a bug in the A2007 runtime. Clint Covington wrote on Jul-20:
"There is a known bug where reports don't work in ADPs. We are working on a
QFE for the issue." That was 2 months ago, and I think the QFE hasn't been
released yet. I'm also not at all sure it will fix this issue, if indeed it
is a bug.
My questions:
* Can you confirm the behavior I am describing?
* Is this a bug?
* Any better workarounds than the one I described above?