I have some experience with SQL Server 2000 and usually build desktop
solutions to access the data using VB.NET but I have a requirement to build
an adp to allow a user to view/edit selected rows from a contacts table on a
SQL Server. My environment is WinXP Pro and Access 2003. ...

In the Data Link properties of my ADP file under the connection tab where
the Test Connection button lives the option whether to "Use Windows NT
Integrated Security" or "Use a specific user name and password:". When the
first option "Use Windows NT Integrated Security" is selected ...

I am trying to build a report application for reporting off of SQL Server.
I have built my form for collecting the report criteria, and have built the
report.  Now I am having problems interfacing my dynamic stored procedure
with the ADP.

what is the best way to make a report with a Stored Procedure as
RecordSource ?

Is it possible or is there a quick solution to the following question?
In msAccess mdb a select or action query criteria reference to a form is
applied that way: forms!formName!ControlName.
Now I am converting mdb applications to adp.

I have a database with a table called "listing" The fields I'm trying to
work with are 'Year', and 'Description'
The result I am looking for is a 3 column table showing the Year, the count
of records for that year, and the count of records matching a specific

Using A2K.  I developed an adp for a client that has a number of reports
which I've formatted for their printer.  Some of these reports are on legal
size paper and landscape.  When I make any modifications to any of the
reports, I send them a new complete version of the adp.  All ...

Can one use the switchboard manager (in MSAccess 2000 mdb) in an adp
connection to a SQL database?
I've created a switch board in an mdb.
Then made a table in the SQL database with the same name, shape and contents.

I am looking for a way to be able to change the connection information
of an ADP without having to venture into File->Connection.
My reason for doing so is if/when I distribute an ADP I would like to
give my clients the ability to change which SQL server they install the

I need to write a query to get the records between two dates. Also I've to
include time criteria.
Startdatetime = '05/'6/2005 10:00 AM' EndDatetime = '07/08/2005 12:00PM'.
I want to get only records for the date specified above between 10:00AM and

I am working on a new project database using Access and SQL Server. The
program is designed for the Theatre Business. For 2 years we worked with an
Access frontend and backend, but the time has come to consider working with
SQL server.

I have a fairly complex access frontend/backend app which I need to upsize
to SQL Server. At this stage I would prefer to use access as frontend. I
have the following questions;
1. Should I keep using the mdb as frontend or switch to an adp (access

I've got a problem using a T-sql syntax.
The jet syntax goes:
SELECT 0,"<<Add new>>" FROM employees
UNION (SELECT DISTINCTROW employees.id,employees.lastname & ", " &