I have an .ADP file which needs to access a table in a .MDB. When I try
to link to the MDB, Access tells me I can only like to tables when the
ADP connects to a local SQL server. TIA
Matt

Hi I upgraded from Access to SQL server and now I have a problem.
With access and the memo field there was no problem when my client updated
from a webform to a specific table.
Now that I have upgraded the client tells me that she is having intermittent

I have an Excel export I am creating in Stored proceedures.
I need to put multiple rows with multiple fields in to one column(field)
Ok I am in over my head.
I created a stored procedure I have included below.

I'm trying to use the NorthwindCS.adp.  If I menu File!Connection..., I can
only sign on as (local) using NT credentials in order to see that
"Connection Succeeded."  If I try to connect using the machine name
ROBERT-0AX0AGG0 the connection will fail.  If I try to log in as sa, the

This seems to have been discussed before, but I am still
having trouble getting it to work.
This is the VBA:
   Dim rst As New ADODB.Recordset

Every time when I execute the MS ADP project, the MSDE wants the user name
and the its password. How can I stop it?
thank you

I need to have a SQL 2000 stored procedure pass an output parameter back to
my MS Access code.  I've got the sp all set up but how do I execute it and
get the value back in vba?
I just need to pass a couple of parameters to the sp so that the select in

Does anyone have an example of exporting data from an
Access project database to Excel??
Or maybe this is not possible??
I am trying to get around the record limit that I hit

On mdb i had some forms that bound to table.
From other form i open the form on praticular record by the where condition
of the open the form action.
On adp somehow it don't work.