I want to open an ADO recordset with rst.open ...
with a stored procedure. The problem is the stored
procedure has input parameters. Is there any way to pass a
parameter(s) to the stored procedure to get back my

I have an Access Project with a list of contracts.  When a user uses the
"new contract" form, they have the option to specify the employee name
(drop-down) who sold the contract.  When then contract is saved, it passes
the contract informtion to a stored procedure to insert it into ...

I'm sure I've had this working in the past...
I have created an ADP to allow some users access to an SQL DB. I have
created a db user which has dbo privileges to the database in question, and
I used this account when configuring the connection in the ADP.

   i     am trying to set up php on me server at
http://www.heha.bigun.serverbox.org/ but get the following error when the
page over the internet, Any one had this problem?? or can help ???
HTTP 401.3 - Access denied by ACL on resource

It appears Access2000 project has a small problem with the timing of the
following events to their actions.
Private Sub Form_Delete(Cancel As Integer)
Private Sub Form_BeforeDelConfirm(Cancel As Integer, Response As Integer)

I currently have a MS Access 97 database, BE/FE configuration. The program
creator set up two versions of the FE, one which works with the BE directly
on the server and one which connects to a replicated version of the BE
locally to allow users to work off-line when away from the ...

Good afternoon!  For some reason, when I have more than
one input parameter listed properties/data field in the
design view foa a form, they disappear.  It's
inconvenient when I want to edit the existing paramaters,

I have two test servers for specific reasons.  Let's call them A and B.
Both have an exact copy of the save database.
I create an ADP connected to Server A.  The app works fine.
I change the connection over to Server B.  The app works fine.

I am using Access 2002 and I upsized a db to SQL. I am
using the MSDE version. I placed the upsized db on the
network and I am trying to connect to it using ODBC. What
I need to do is having Access as a front end and SQL as a

How can I change the server connection in an Access ADP file if the original
server is dead?
The ADP file will not open.
[I'm using Access 2002 - Office XP]

I've got an A2K adp that allows the user to select one or all medical
residents for a report.  I'd like to allow the user to select more than one
resident as well.  Creating a stored procedure to select just one resident
or selecting all residents is simple.  If this were an mdb, ...

I have an ADP project, MsAccess 2000 and MS Sql server 2000.
I have a sored procedure that is using temporary tables. In query analyzer
it returns recordsets, but when calling the same sored procedure (with the
same parameter) from access it does not returns any records.

After upsizing, I get the above message on all of my
tables.  How can I get around this?  
Thanks anyone,
Ned

I m trying to run this code , but i dont know how insert the parameters of
the store procedure, someone can help with this????
This is the code of the form:
Option Compare Database

I hawe a project adp 2002 that work well in some PC but in some PC
when the user click the x to close the program access wait a lot of
time before close it.
This is in a net with SQl Sever and client with XP and win98. Some