VB Forum / Database Access / November 2003

Using Visual Studio 2003, I know I can debug a stored procedure, which
prsents a dialog box to *TYPE* in the parameters to a Stored Procedure.
What I desperately want to be able to do is Use a ADO command object to call
a stored procedure and then be able to debug step from the VB ...

Chirag
I am facing an error when i am filtering the data in the recordset
"Filter cannot be opened"
Can You predict the cause of it

is it possible to use dao 3.6 object in asp page. and if yes than how to
create dao.dbengine and dao.database object in asp
thanks

I need some help pleaseeeeeeeeee!  I can open a password
protected database using
set db=ws.opendatabase
("c:\.......",false,false,";pwd=nnnnn")

To do a PACK command call in VB using OBDC call for a DBASE file? I need to
clear out a table, but the DELETE FROM statement is not enough to delete
everything from the table...
If anyone can help me...

I work on a vb6 software accessing sql server 2000 with ado2.6 ... and I
struggle with a weird problem ...
When changes are done by two "users" on the same field of one record,
usually the first update is accepted and the second raises the

To do a PACK command call in VB using OBDC call for a DBASE file? I need to
clear out a table, but the DELETE FROM statement is not enough to delete
everything from the table...
If anyone can help me...

All,
Where can I find some sample code to extract an image from an ole field in
an .mdb file and save it as a separate file, i.e. a .bmp or .jpg file?
Thanks,

I have written the function to upload the CSV File from asp pages.
I want to extend that upload facility to semicolon delimited file.
I use ADO to upload the data and it reads the input file in ADO Record
set.

I'm writing an application for which the database built in Access 2000 will
reside on a cd rom.
I am looking for some tips for enhancing the speed of query.
During the first access to the database, the cd has to start up, the file to

I plan to convert some Access 97 databases to Access 2003
and continue use these bases from a VB 6.0 application
(DAO).
1)What library components should I install on my clients

datagrid.col width ????
Is it possible to use the len(fieldname) to determine the length of data
returned to a datagrid and then size the columns to match that
len(fieldname) size?

I am trying to find the correct syntax for the last line
in this code example for the SQL String.
    <% @Import Namespace="System.Data" %>
    <% @Import Namespace="System.Data.OleDb" %>

Having a problem, I keep getting field names instead of the actual
values in the database. Can anyone help?
Here is the code:
Private Sub cmdReportsGenerate_Click()

I just want this simple thing:
*****************************************************
*** get the columns headers in MSHFlexGrid fixed ****
*****************************************************