I am migrating an Access mdb which has the tables in one mdb on our
server and the mdb front end installed on each workstation with the
tables on the server linked to an adp with a sql server 2000 backend.
However, with the mdb I have used a local table to temporarily hold a

I am creating an adp in Access 2003 at home and connecting over the
internet via a VPN to a SQL Server database at work. Firstly, when I
create the adp it tells me it has done so in Access 2000 file format,
is this right? Secondly, although I can initially connect to the SQL

I have ADP (Access 2003) nad I have difficulty handling ADO errors.
I have table that has some fields that have to be unique. When enters
udplicate data in these fields, he gets an error:
Violation of Unique key constraint 'XXX'. Cannot insert duplicate key in

What are the consequences of keeping forms and controls bound in an ADP
(when converting from an MDB application)?
Thanks
Bill

Pretty much as the subject says,
I have an ADP linked to a SQL Server 2000 database. On one table I have a
FOR UPDATE trigger used for auditing purposes.
When attempting to update that trigger in the ADP - be that via a view or

Well, the title says it all...
I believe it should be possible...
Anyone doing it for "real" ?!
Regards

Maybe this obvious to most of you, but....
Searching on "@@Connections" in BOL
or on Google has proven exasperating.
When I debug a Stored Proc in Query Analyzer,

I was having issues with my form not showing the correct number of records so
I put in a MoveLast and MoveFirst cycle before I get the recordcount and it
works fine but my form flickers as it cycles from last to first. I put in an
echo=false but it's still flickering. Is there ...

I have a working .ADP project that uses a large demographic information table
on an SQL2K server.  I also need a link to an Oracle database so I can get
the billing details for that demographic information.  Is this possible? If
so, could someone point me to some examples?  I ...

What is a good way of displaying data from dynamically created SQL?
The SQL is created based on user selections, so I can't have controls on a
form or report bound to fields in the resultset in advance.
The way I'm doing it now is by creating a view dynamically based on the SQL,

how can I use an Access project with user's level security (mdw) ?
is it possible ?
Everaldo Ricardo - br

I have an ADP/SQL Server table that has a column called "Document" with
data type = image.
Does anyone have an example of some VBA code that I can use in the
OnClick event of a form button that will retrieve the long binary image

Estimado amigo:
Si estás buscando una guía de referencia que te ayude a desarrollar
aplicaciones Cliente Servidor con MS Access y SQL Server, te presento
"DESARROLLANDO APLICACIONES CLIENTE SERVIDOR CON MS ACCESS Y SQL SERVER":

I could''t create this property in adp, despite register DAO, is it possible
?
Everaldo Ricardo - br

Hi guyes . I am looing for a simple to use tool that easily convert th
access 2000 query or sql code to sql server 2000 code and visa versa
Thank
--