In Access, if I want to create a new one it gives an error.
If I create it in SQL it works, but as soon as I want to start it in Access it says again it can't find the procedure (but it does mention the the SP I created in SQL).
And the SP I made asks for a beginning and en ending date and...
In references I have:
* Visual Basic for appl.
* MS Acces 9.0 Object Library
* MS ActiveX Data Objects 2.7 Library
* MS ADO Ext.2.7 for DDL and security
* OLE Automations
Is this okay?
SQL Servers is (I Think) 2000
Code is ok, as I have tried a stored procedure from Northwind and that one is also not working.
Ref. to permissions, I am the database owner and have permission to execute SP. Which more permissions do I need?
I am a rookie: where can I see about the ADO libraries?
I still have this problem.
There are some SYSTEM-SP in de SQL-server but when I try to open them it results in an error.
Same as I want to create a new one (in ACCESS). It says "can't find the object".
Pls help....maybe the installation from Access is incomplete??
Thnks.
The reason I am using a View is that my Access does give errors when I want to make a Stored Procedure. It says it can't find the procedures....
Very strange, but everything else is working....
Hi,
I have a problem with giving a criteria for a query.
I have experience with BETWEEN and FORMS!FrmName!Control.value in ACCESS but this does not work with Access Project/SQL Server.
I want to give a criteria in a form and with that criteria I want to open a report.
But when I enter a...
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.