I am trying to use a stored procedure within an access .ADP that first
creates a temporary table and then uses it in conjunction with other tables
to generate a record set.  When I run this through Query Analyzer this seems
to generate a single rowset, however when I run in through ...

I have Access 2003.  I recently installed SQL Server PE, i
think it's version 8.  I have created a database in the
Server and have opened a project and all of my tbles are
available.

I have a frontend (*.adp) - backend (Sqlserver) application.
I made a command button on a form that takes the current record,
duplicates it and then displays the new identical record.
When I compile the procedure, I haven't errors, but when I click on a

I have a problem which i need some advice. I have a mdb connected to SQL
server 2000 and that server has 2 databases. I followed the below link to
create DSN for connecting those databases using a form in my mdb. When I
switch between those databases a seperate set of new tables are ...

Access as frontend for Firebird?
Is anyone using, or exploring the possibility of using MS Access in
any way to access / manipulate / edit / display or report on data in
an open source SQL database like Firebird (similar to Interbase)?

I get an incorrect syntax error at 'INNER'
CREATE PROCEDURE [SP_UpdateTable] AS
UPDATE TableName INNER JOIN TableName_Audit
ON TableName.[ID] = TableName_Audit.[ID]

I have inherited an Access adp that directly connects to SQL Server.  My
knowledge is mostly at the SQL Server level and I have worked with older
versions of MDBs - Access 97 and previous.  I created delete, insert, and
update triggers on the table an Access form pulls up through ...

Is there any way to have bound forms and not having to grant direct access
to tables with ADP.
When using SP's, views or functions as a recordsource of your form you
still needs to set edit permissions on your tables if you want your users

I Recently migrated an Access 2000 database to SQL server using an Access
adp project as front end.
When a user logs on, I can see 3 connections per user open in Enterprise
Manager for the application even if no data has been retrieved from the

I have a form with a stored procedure as the record source. In that form, I
have a list box that requires a paramater but I can't seem to get it
working. I tried:
listbox.recordsouce = "EXEC StoredProcName '" & ParamaterName & "'"

I have upsized a database, and now I need to change 1 thing in every query.
Problem is, functions don't seem to be editable (at least not in SQL).
How can I change 1 table to a different table in a function?
Thanks,

I have an Access Data Project (Access 2000) that links up to a SQL Server
on the backend. I have a stored procedure on the SQL server that accepts
two paramaters and then executes an update command. My question is how do I
reference the stored procedure and pass it the two ...

I want to conver the expression below from an Access MDB to use as an
expression in a SQL Stored Proceedure in an Access ADP and cannot seem to
get the syntax correct.
IIf([CheckBox1]=True,"Indiivindual Policy","Family Policy")

I want to use the following VBA code form and Access MDB in an Access ADP.  
What is the correct syntax for T-SQL?
Private Sub Form_Current()
   Dim rs As DAO.Recordset

I am using a stored procedure to update an sql server table from an Access
front end.
When I move off the record, I get a "write conflict" message offering to
write the new data, copy to the clipboard or discard,