Unanswered Access 2007 Runtime: Stored Procedures as Record Source

  • Freitag, 15. Februar 2008 05:04
     
     

    Hello

     

    In our company, after switching to  Office 2007,   Access 2007 runtime is installed on our general user machines.

    Everything is just fine and beautiful, except that there is one issue with runtime:

     

    Several forms in my Access Project  use stored procedures in SQL Server 2000 as their record source. When i try to open the forms in Access 2007 Runtime on user machines, i receive  an error that "The record source dbo.Myprocedure speified on this form or report does not exist ".

    I use dbo.ProcName format  and the forms open correctly in my full version  Access.

    What could be the problem?

    Thanks!

    Elman