I have just setup my first sql 2000 server database with adp client front
end. In Access 2000 I had no problems with queries and reports.
With Access data project, I am having problems with crosstab queires, and
crosstab queires with parameters. Can anyone point me in the right ...

I have a fairly simple query (using SQL and ADP) that looks at an orders
view
and returns the folowing fields for all sales details:
Item

My company is using CITRIX MetaFrame to allow access to
our corporate Intranet, which has the abilty to launch
several MSAccess applications.  THe .MDB work fine but
there appears to be instancing issues with the .ADPs.

I want protect a form with password, somebody can tell how i can make this
in ADP file.
Thanks
Alejandro

This book caught my eye for Access/SQL (ADP) development but although
it is a Microsoft Press book and was written in 2002 - its out of
print.
I found a used one in the UK for almost $500!!!!  What the heck?

I found an interesting article on the microsoft site about migrating from
Access to SQL Server 2000.  It references white papers which also look
interesting.  For example it says:
Readers should be familiar with the differences between Access and SQL

System: Windows XP / Office 2003 / SQL Server 2000
All updates installed (windows / office / sql)
This is a new behavior detected today. The same solution worked fine since
last operation.

I have created an ADP project that is a "generic" application that sits on
each users computer.  I have code in the ADP to change the connection string
so that the user can select different databases the ADP connects to.  (the
different DB's are strucurally identical).  The ...

Am I right?
If my table does not have primary key then I could not edit the table form
ADP.
If the table has primary key then I am able to modify the table.

Is it possible, in an Access ADP, to use a configuration file or the
registry to store your ADO connection string parameters? If so, how do
reference either the config file or the registry w/in Access? Is there a
better way to create a dynamic connection string? Say the Data Link ...

I have an SQL statement that retrieves all of the items in the items table.
When i display the data I want to have a number before each of the records
so that it looks as follows:
1   xxx   yyy   zzz

I recently converted from a .mdb file to a .adp front-end for a backend
running MSDE. There have been dramatic increases in performance, and I'm
happy with the conversion. However, one feature of the database--Microsoft
Word 2000 Automation-- is causing headaches.

I'm converting an mdb database application to use a SQL backend and moving it
to an ADP.  One of the first things I do is check for the existance of a
table by looping through the tabledefs object.  It works in the mdb, but not
in the ADP.  I have the reference to DAO 3.6 and it ...

Just a quick question.
Can I use ADP to generate SQL scripts or not?
Souris,

I have an ADP app that is used only for reporting.  The users don't change
or create new reports, they just run the ones that are there.  The problem
is that if 2 users have the ADP app open, I get the error,
"The MS Access project 'Name' will be opened read-only because on of the ...