In an ADP project (Access 2003), I'm trying to use master/detail form feature,
but I'm getting a problem.
Both the master form and the detail one have a stored procedure as record
source (obviously SPs are different).

Can I use Access 2007 to connect with and write SQL to SQL express or Server
2005?
Can you use the Graphical Interface to do it?  Or do you need to use TEXT?
Thanks

Here is what probably is a stupid question, I do this all the time in
coldFusion, but I would like to do it all in transact-sql. Basically, I have
table A with records, I want to loop over the records in tableA and insert 1
(or a few) in tableB essentially:

i have a table that i'm pulling records from where i want to limit my results
by multiple criteria.  i'm stuck on a particular field ([Ordered Options])
that has a list of option codes, all 3 characters long, separated by commas:
B37, C60, FE9, J41, L61, MN5, US8, 19G, 41U

I am using AccessXP and SQLServer 2000.
I developed a stored procedure that sets derived values from input parameters,
and then uses those values to select data.
When I set the recordsource for an adp report, it sees the report but does

Background:  I have 4 databases, 2 that are MDB and 2 that are ADP.  The 2
MDB are split databases that link to MDB back ends. The 2 ADP databases are
linked to SQL server.
Problem: I want to use a MDB front end to connect to both the MDB backend and

Ah! I am done upsizing my access database to SQL. Works great!! I transfared
it to my server which is Server 2003 and it works I used the trusted
authantication and thus no logging in is required for me. Now 2 problems: the
rest of the clients cannot use it. It says there are not ...

I am trying to create a stored procedure in an Access adp. I am trying to set
a parameter with a default of today's date, so I tried to put in GETDATE()
and it gives me an error:
Literal of the correct data type required.

L..S.
I'm creating a coding using the tables of an ODBC SQL Server connection.
I'm searching in a table on the SQL server using the following code.
I'm receiving however the data of the first record in the table as output.

Help!  I don't understand why I am getting the error message:
"Implicit conversion from datatype datetime to int is not allowed. Use
the CONVERT function to run this query."
I am using parameters to find records in a range of dates in a

I was writing to get ideas of what everyone thinks.  I am wanting to start
my own business and was wondering what everyone would be interested in
seeing started?  Any ideas would be appreciated.  Thanks
Matthew

I am trying a pass-through, but it has null information in some of the
parameters I have setup.  My pass-through query when executed is giving me a
message box of Invalid Use of Null.  I am looking for any ideas on how to get
a Null to SQL Server using the pass-through.  Any Ideas? ...

so oftoenWe run an Access 2003 database.  Some of the tables are linked to a
SQL Server 2000 database located on the same server that the .mdb file
resides.  We have always had issues where, during the day, when someone would
get a message saying that the database needs to be ...

This is the first adp I've worked with so I'm pretty new at this.
I'm using Access 2003 with SQL Server 2000.
I keep getting an error:  Line 1: Incorrect syntax near '/'.  When I
try to execute a stored procedure from a button.  Basically what I'm

Do ADPS work with SQL Server 2005 Express ?
In the Data Link dialog, when I hit the Refresh button I get a message  
'Error enumerating servers...'
Any ideas anyone ?