I have a form bound to a stored procedure with a 1-many
relationship. I understand that this form is not
updateable since the stored procedure has a parameter. The
many side has a check box, where I would click a check box

Before I converted from MDB to ADP I was able to import data from Excel and
.CSV files directly into Access Tables.  Microsoft did not include the
ability to save the import specs when using an ADP or ADE.    I discovered
that somebody wrote a module that would allow us to ...

I want to setup my report so that a user enters in the SSN of the employee
they want to report on and it goes to the view and filters the records that
have the certain SSN.  Is there anyway to do this with a view or will I have
to use a SP?

I can't find documentation that explains the syntax for
disconnecting from a SQL Server and connecting to another
in an Access adp.  Can someone let me know where I might
find this or post an example.

Good afternoon,
I have just ported my MDB app to the SQL Server using the
ADP platform, but I have one outstanding issue:
When I execute one of my stored procs through an ADP form,

I want to create a databse that is accessible thru a website that will
allow me to keep track of plays that are going on around town. I want it
that i can fill out the details of a play (actors producers etc...) and
when i am viewing one record i can click on an actor lets say ...

I have an ADP that sets the bound forms Recordsource to the results of
a stored procedure. The code in VBA I have that sets the forms
recordsource
is:

I got handed a little project where a person left something hanging…
The code that is failing is
Dim adoConn2 As New ADODB.Connection
Dim RS2 As New ADODB.Recordset

How can i link in mdf-File into an adp-Project?
with wich code can i do the same as the command Datei-Verbinden-Transact
sql?
Thanks! Steven

I have come across an interesting issue.  Whenever I add records to an
access database in a datasheet subform, I receive #deleted when I enter back
into the form.  The records do however exist in the SQL database.  I found
this kb article on the subject and it tells me to ...

I want to create a databse that will be accessible thru the web, for
updating and viewing information using a webpage, how would i go about
doing this? the databse will be sort of like the imdb.com's database. thank
you

Can someone please explain to me why the below code produces
Run-Time Error '7777': You have used the ListIndex property
incorrectly.
The error occurs on the second last line of the code?

I am using the two combo box in my form to contorl the record. the 1st
combo box dispaly all the groupitem. and the 2nd one display the items
with in the grop selected in 1st combo box. its working nicely except
i have small problem or sorting.

I have a UDF with three parameters, the last of which is an email address.
The function works fine in query analyzer. However, when using the following
statement in my Access 2003 ADP's report recordsource...
SELECT * FROM udf_GetUserInfo (Null, Null, 'john.doe@nowhere.com')

hi group!
i have the following problem using an insert trigger on a table with an
identity column as a primary key -> every time i add a value using my form i
get a message that the data can not get displayed -> I know there is the