| Thread | Last Post | Replies |
|
| ADO Connection | 05 Sep 2007 09:10 GMT | 2 |
Just wondering what way people open their ADO recordsets.
Is one method better than another?
1) Dim an ADO connection
Dim cnnADO As ADODB.Connection
|
| Restricting Access to View's in ADP | 05 Sep 2007 00:53 GMT | 1 |
My organization has a networked SQL database that we wish to allow users to
run adhoc queries/reports against by way of an Access Data Project.
Ultimately, we would like to have our users connect and only be able to
access views that have been previously created within the SQL ...
|
| 5656 | 03 Sep 2007 19:30 GMT | 1 |
|
| A2007 ADPs | 03 Sep 2007 19:28 GMT | 44 |
Just some general comments and the odd question about A2007 projects...
Currently I am upgrading an Access 2002/2003 ADP to A2007.
It is a large application that was originally upsized from an .MDB to an
.ADP in Access 2000 for scalability, reliability and performance reasons
|
| count function - calculations | 03 Sep 2007 13:56 GMT | 3 |
Hi everyone. I need expert advice.
Can one write a query that will calculate the count's average?
For example:
Select count(orders) AS Total, Total*4 AS NewTotal
|
| Form using stored procedure does not work in Access Runtime | 01 Sep 2007 07:38 GMT | 5 |
I am using a parameterised stored procedure as a recordsource of a form.
When the form is opened on a machine with full Access everything is working
fine. However on a machine with only the Access runtime the form will not
open. In both situations for the same SQL account. What ...
|
| open report is slow | 01 Sep 2007 06:16 GMT | 7 |
I'm working with ADP 2003.
When I open the database and I open any report for the first time it take
time, after I can open any report quickly.
For example, I have a report, when I open the database and I open it, it
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread