Search results for query: *

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....

Indeed a view. I have a table MCO with MCOnumber en Date In a textbox on a form I want to give a date and then a report must print on that date.

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...