I am trying to create an SP which
 (1) populates a temporary table from sp_helprotect ("INSERT . . .
EXEC sp_helprotect");
 (2) cursors through the temp table to update a user table;

I am migrating my MDB forms and reports to ADP (2003) connected to SQL
Server 2000.  My forms are bound to the currentproject connection and single
tables on the server.
Very basic question:

not very familiar with ADP, so I'm not sure I can do this.
Double-click on a stored proc in the Stored Procs view in Access.  It
prompts me for two parameters.  As expected.  Then it opens the
resultset in a normal Access "table/query view data" window.

Hi all. I'm experiencing the following problem: I have an ADP db linked to
SQL Server 2000. Through a form I launch a SP using the method
CurrentProject.Connection.Execute and then open a report with a DoCmd. The SP
initially empty a table using a DELETE and then populate it with ...

Computer A is where is installed SQL server 2000 and the BE. Computer B, I
have the FE (ADP in access 2003). The both computers are connected the
internet.
So, how can I connect to SQL Server over the internet? I mean, I want

I have a udf with a date column and I would like to be able to filter
returned records by passing  NULL as a criteria. I set the column default
value to NULL. When I open the function and select either default or null
from the drop down I get no records returned. This in not a data ...

I have developed an application that displays data from a query in a
subform.  This worked fine when I developed it with the SA account but when
creating specific accounts for users, no data is displayed in the subform.  I
have granted rights to all tables and stored procedures.  ...

Estoy trabajando un Adp, acces 2003, sql server 2000
estoy tratando de adecuar este codigo para que me copie en una tabla fecha
las los fechas que encuentre entre dos fechas...
estoy empezando... la he modificado pero me envia un error.."Variable de

OK, I'm baffled. I have an Access applicaiton fronting SQL Server and
used by 15-20 folks at any one itme. One of the features is to fire off
Word sessions to open documents which are mail merges into the active
record. The key peices of VBA code looks like this:

Hi--
I am a developer looking for a way to allow clients to deploy updates
at the click of a mouse. I have the batch files done as far as the sql
statements and copying the new adp to the correct network location.

I have a Microsoft Access ADP that goes against an MS SQL Server 2000 database.
Within this MS Access ADP I have a recordset (forward only, read only,
cachesize 1) that is the result of a SELECT. . .WHERE EXISTS query. This
recordset is gone through to create corresponding records ...

I want to write code that will skip any record that displays 'Yes' in the
[Ignore] field.  Since this field may change throughout the day, and my
employees are in the system nonstop, I cannot make it a filter.  
This is what I came up with, but it didn't work:  Form Current:

Is it possible to base a form on a stored procedure that has 2 or three
joins and be able to add records back to the database?
I have a fairly straight forward SELECT in a stored procedure that when
run in MS-Access ADP does not offer a "New" row in the results grid but

I am converting an existing change request app from an mdb to an adp.  The
mdb has an existing query that has an interactive keyboard entry built into
it. For ReqID field the query criteria has [enter ReqID] which works fine
in the mdb in a popup form.  That syntax does not seem to ...

please respond to this thread with the annoying things you would like fixed
in Money. I will try to reproduce them in the next Money Beta, so there will
be a chance to have them fixed.
Ideally, please post in the form of steps to take/expected result/real