I am trying to create a table with a multiple column primary key. When I run
the code below I receive the follwoing error message:
"Cannot add multiple PRIMARY KEY constraints to table 'Daily_Price_ImportT'"
What is the correct coding to create a table with a multiple column ...

I have an Access ADP, developed and all working happily in Access 2000.
However, if I send this to an Access 2003 customer without first
disconnenting it (I've put some code in to drop the db connection) then they
run into all sorts of problems when they first try to open the ADP ...

I'm using Access 97 as the front-end (yecch!) to a SQL 2000 database. I want
to upgrade Access to a version that (hopefully) works better with SQL
Server. I'm looking at Access 2003. My FE has a lot of local temp tables in
it. What I want to know is, is it a better idea to switch ...

I created an Access Data project to connect to an existing SQL Server
database.
I connected using the "sa" login name.
I cannot edit the data in the tables.  Tells me "recordset not updatable".

The simple(?) problem is:
We have a Table 'Batch', with 2 columns: Batch and State, with this data:
Batch   State
A       3

I have upsized an Access database to an SQL database via the Access upsizing
wizard.
The first few times I did this all was ok (ie I could enter / edit data in
the SQL database via Access).

I want to be able to compare a user-supplied date against a smalldatetime
field in a query.  It looks like using the # sign is a mdb thing only.  Do I
use the Convert function on the table's date field to convert to a
"formatted" smalldatetime and then compare?  This is what I've ...

I am putting together a project for a client as follows:
1. Client HQ: SQL Server 2000 database + SQL Reporting Services
2. Client Site: ADP front-end --> SQL db (Client HQ)
3. ADP front-end --> URL link to Reporting db

I am trying to create a basic form in an Access 2000 .adp file. My two
tables are Products and ProdPacks. Products contains the product name,
description, etc and ProdPacks contains a list of SKUs for the various
packaging options for each product in the Products table.

I have an issue that is somewhat perplexing.  In an ADP project with Acc2002
and SQL Server 2000 I have a view made from 3 tables, two views and a
function. A couple of these objects have more than 10000 records. The view
returns 740 records when the maximum records setting for ...

I realise that CurrentDb returns Nothing because there is no current Jet
database in an ADP. So how does one get a reference to the default database
connection? In bound forms I've been using Me.Recordset.ActiveConnection but
in an unbound form this doesn't work for fairly ...

Does anybody know how I can read the value of the Caption property of a
SQL Server field (as set by Access) at run time?
I need to export some data to Excel (I can't assume it'll always be one
kind of data - I want to be able to pass any SQL string and spit out an

I have been playing around with access 2000 and msde. My question is this:
If I find a company that host sql server databases, can the tables be in
Baton Rouge, LA and the Microsoft Access .ADP file be in Dallas, TX?  In
other words, can you connect to remote ms sql tables that are ...

I'm using sql server 2000 and access 2002. I have a maintenance work order
form setup to send a report using the click event. I want to start using sql
mail to do this so I've setup sql mail and have it working. But now I need
some information on how to execute the xp_sendmail ...

I have a combo box with a stored procedure as a row source and I want the
first item in the list to appear instead of it being blank.  I used the
ComboBox = Combox.ItemData(0) and it worked until I made a change to the sp.
I adjusted settings on the combo box to be 3 columns instead ...