i have a function that returns a boolean value.
the value is getting changed properly within the function, but always
retunrs false to the calling subroutine.
any clues what might cuase this?

I connected SQL Server from my FE created in access 2003 (ADP) from one
office to open a report spend 5 seconds, from another office and from
another coutry it spend about 20 seconds.
The time to open the report depend only from internet speed? Off course for

Please help me out with this!
I am connecting to SQL Server 2005 through .adp project connection.
For some reason I cannot increase CommandTimeOut property, it is always set
to 30 seconds.

Dear friends,
I have a SQL Server database and an Access adp frontend. I use DRI
(declarative referential integrity) throughout, with one exception. I have a
table Projects in which I save the names of several people working on the

I seem to have come across a problem when transfering data from my VB
Questionairre application to an Access database.
The application is set up so that users go through answering multiple choice
questions and a comments box. When the submit button is clicked, the data is

I'm developing a database in ADP, access 2003.
I run the following function
Public Function test1()
Dim cnn As ADODB.Connection, rs As New ADODB.Recordset, strSQL As String

I use an access database  and sql2005  All is good when the two databases are
on the local computer but I cannot  use two differents computers because I
cannot connect from Access in that case. Can you help me Thank you.

When I open form with subform I got next error:
"Syntax Error or Access Violation" and subform area remains white.
Any ideas how to solve this?
I found same problem here:

Might not be the best place for this question.  But here goes:  I have a web
application which stuffs parameters into Access ADP reports.  (The user can
select to output the reports in rtf, html, PDF, excel PDF, and snp formats.)  
The rendering works great except for users who ...

I have an access database with tables, and links to tables in an Oracle Back
End.
I want to move all my access tables to the backend, but feel I will be unable
to add

My access always hangs after having Visual Basic Express 2005 install. It
appear to have conflict between the two SQL version. The SQL 2000 service
won't start. Anyone have solved this problem before?
SF

I have a database that a select few people will access via an access ADP
project (using Windows Authentication). Potentially anyone could open the
ADP file (though they shouldnt), but I would expect that they wouldnt be
able to edit the data unless I give them permissions in SQL.

I am having difficulty getting it set up to use a form to pass date
parameters back to a stored procedure in my adp.  This is my first adp so I
am trying to get used to differences between mdb and adp.
Anyway,  I searched and found code like this:

I've read quite a few posts about the lack of Access design support for Sql Server 2005, but have a few questions.
My understanding is that no current version of Access supports designing objects in SqlSever 2005 (as an aside, if this is true it
is a cock-up of truly monumental ...

Need some expertise for this one...
I have a SQL stored procedure that returns a value 1 if a match is found in
the table based on 2 parameters.
Here is the SP: