VB Forum / Database Access / May 2004

Does anyone know of a version of DAO that supports Access 2002/2003 databases
The help says to specify Version=1 thru 4 when using CreateDatabase
These values correlate to Access, Access2, Access95 and Access2000
I would like to be able to create Access 2003 format also.

I am trying to connect to an MS Access database, using ASP and ADO.  I
know when I try to do this locally, I just need to set up a System DSN
data source and call that in the ADO.
When I want to move this app (populating drop downs from an Access DB)

I've got a problem with a datagrid control .I've got a form with and ADO
data control and the datagrid control : the Data Control is connected
to a MSDE 7.0 db with a simple "select * from mytable" . The datasourc
property of the datagrid is set to the datacontrol

Hi - I'm using MyVbQL.dll with MySQL. Unfortunately I can't use the VB6 Data
Report with this, and the recommendation is to use Crystal Reports.
I remember having sight of CR some years ago when I think it was bundled
with VB5. How to I get it for VB6? Is it free and downloadable or ...

this is probably a silly question but...
when i...
"SELECT * FROM tblMyTable WHERE d_sent IS NULL"
i then use...

I am using disconnected recordsets. I have a problem with the CancelUpdate
method. With the disconnected recordset I may add new records and then call
the Update method. Later on, I edit the record and then call CancelUpdate to
roll back.

Thanks in advance to all.
VB 6 using ADODC
I want to set the connection string at runtime.  WHen I use the following, I
get this error message: [Microsoft][ODBC Driver Manager]Data source name not

I am getting an error with description "Unspecified error"  with error
code -2147467259 when I try to execute any query using Visual Basic 6.0 via
ADO 2.6. I have both MDAC 2.6 and 2.7 installed. It was working fine until
MDAC 2.7 is installed due to the installation of SQL Server ...

Today's excursion into programming starts with one of the weak links in my
armor. I need a good book in the intermediate to senior range for SQL. I
will eventually end up making my own databases. I can see at least three
separate DB's. I will be using MYSQL on the web and here at ...

Does anybody have the code snippet for updating and retreving the Image
column through stored procedure using ADO I m using SQL server 2000 as a
backend.
Can we using PictureBox control for this (i.e without reading from the image

I'm having trouble using eval to pull information from a database
connection.  The information I need to retrieve is stored in another table.
   Example:
       Column1 = "idata.B3"

 I have files upto size of 100 MB to be uploaded into SQL Server 2000 from VB 6 Application with MS Access XP as client database.  I was able to save and retrieve that data from MS Access database using OLE Object data type.  Now to insert that data into SQL Server 2000 into an ...

When I open a connection to a local MS Access 97 Database using DAO, would I
need to close the connection after doing what ever I need to do with the
records within a table.  If I do not close the connection, can I keep
querying the database.  Is there a timeout on the opened ...

Can anyone tell me why this code fails to return the output parameter from
the SP.
VB.Net Code ----------------
Dim adoCmd As New ADODB.Command

My application is designed with VB6.0 and SQLServer7.0. When my
application starts I have a window with the list of databases. To get
some information from each database I have to connect to them in turn.
I use ADO 2.7 to do it. It goes without problem. After connection to