I am new at coding adp and sql server.  I am having trouble getting a
single output from a stored procedure.
Prodedure:
CREATE PROCEDURE dbo.spGetData (@ContactID int,

I have the following problem: when I run a script with a sql query that
deletes a row in a table, a dialog box pops up and asks if I really want to
delete the row. How can I disable that box?

To anyone who can assist,
I'm still relatively new to access and I'm trying to wrap my mind around
implementing an application role.  The idea behind this is that I'm hoping to
avoid having to create 1000's of user logins for access (select, update,

I am producing a form which uses fields from record source "A" but also want
to refer to some data in record source QRY X.
I am  trying to write an expression in the form which calls on data from the
query and using the the full expression [QRYX]![data] to refer to the data in

I first posted this in Access Database General Questions but then found this
more apporpriate newsgroup, so pls forgive cross-post:
We use MS Dynamics (Great Plains v 8.0) accounting system on SQL Server 2003
and I 've connected an .adp project (MS Access 2003) to the underlying

I have created a new adp with a SQL Server backend.  I have the adp
file on my laptop and the SQL Server resides on a remote server that I
access via a VPN.  When I open up the adp on my laptop and select File-

I have one stored procedure
It has Two Output Parameters
It returns Empty values
While debugging i have inserted Insert statement In Procedure

I have an update where I specify the following:
    string updateSQL = "update  Perform " +
    " set venueCd = ?, " +
    " performanceDTTM  = ?, " +

I need to connect an MDB file on one computer to a SQL server express
database on another computer on a network. Any links on where I can go to
learn to do this?
Terry

We are upgrading one of our mdb files to sql server 5 express because it has
gotten two large. We are good at access but no experience in sql server at
all. We have downloaded and installed Sqlserver express and tried to run the
upgrade wizard in access, but we are not having ...

In Access, an autonumber is generated as soon as you change any field of
the record whereas SQL Server doesn’t set the autonumber until the record is
saved.  In multiple places in my code, I use the Addnew method to create a
new record, set the value of a field (for example ...

I am looking for someone to help out with sql statements to use with
removing duplicate records in an address field based on matches and removing
older records with date and time stamps.
Can any one help.

Hi, can anyboydy tell me how access 97 performs within a single
table/form/query environment if the table holds about 21,000,000 (english
millions) rows, 5 columns? no indices, 1 primary key. query on primary key to
return up to a max of 100 rows.

I have an ADP that I allows me to do table design work on tables with
BIGINT fields if I use Access 2003 but not when I use Access 2007.  It
looks like someone 'fogot' to tell Access 2007 that BIGINT is a valid
SQL Server data type.  This is the error I receive:

I am building an application in VB.NET... It connects to 2 databases MS SQL
SERVER 2005 and MS ACCESS 2003 .. It works all fine with SQL but It only
reads the record from the ACCESS table which is linked with SAGE ACCOUNTING
SOFTWARE V 11... Now When i Update or add record to the ...