With access XP as front end and MSSQL SERVER 2000 As Back End:
It not satisfying me using "DoCmd.OpenStoredProcedure" when Executing non-select SQL, and I still questioning the effectiveness of using ADO in VBA.
Is somebody know the best way?
Thank you
I develop database (SQL SERVER 2000) on Ms. Access. One of my client user report that some forms and reports not working. When I open the database windows I found the stored procedure name added with ";1" and whwn I dbl click appear message that the file is name is not found. How to...
I develop MS SQL database at home. When I attached in Server and I open it by Ms Access the stored procedure name added by string ";1" and the stored procedure can not executed at client. Why and how to solve it?
I develop MS SQL 2000 Database by Ms. Access but one of the client cannot execute storted procedures. I found strange additional suffix (...,1) in the stored procedure when I opened it in database window. Why and how it can happen?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.