| Thread | Last Post | Replies |
|
| HELP !! Running SQL 2000 using ADO command object from Access 2000 | 11 Jan 2007 16:11 GMT | 2 |
I'm running a SQL 2000 stored procedure from Access client using
SQLOLEDB provider and ADO Command object. The stored procedure only
returns a Return Value and no recordset.
When ran from Query Analyzer, it runs in less than 4 seconds. When ran
|
| Indicating stored procedure progress - To Sylvaine | 11 Jan 2007 06:35 GMT | 2 |
> 1- You are using the same connection for calling your SP than the
> connection used by Access to open the second form. Try opening a separate
> connection to query your table. |
| Subform Subform Subform | 09 Jan 2007 20:57 GMT | 3 |
Dear Friends,
Thanks in advance for any response from you.
I have a peculiar situation: I am using ADP with SQL backend.
I have a form Shpmtfrm, which has a subform EntrySubfrm, which inturn has a
|
| closing DB connections | 08 Jan 2007 21:40 GMT | 20 |
I have an ADP in which I am making lots of connections within the VB code to
the SQL database and then closing the connections. In addiotn, I am
creating lots of recordsets and then setting the record sets to nothing when
I am done.
|
| Extracting Field Titles - newbie question.... | 05 Jan 2007 19:03 GMT | 1 |
I'm new to SQL Server and am mainly writing simple SQL then copying the
results into Excel and then messing around with it.
At present, once the query has run I go to the result grid and right
click on the top left cell and then do Select All and then open an
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread