VB Forum / Database Access / August 2004

 I want to create a data report to present the data from a database,
but is it necessary to use a dataenvironment? From my knowledge, I
just know to create a data report by dragging the sql command in
dataenvironment into data report. Can I do this without

I'm new to visual basic and am trying to write an application in VB6 that I'm in need of some advise with.
I have a Microsoft Access 2000 database that sits on a web server.
I will be updating a table (called Locations) in the database on a daily basis using a linked table from my ...

Hi, I have a huge array of over 100,000 rows that I need to dump into a
table.  I tried calling an insert sp but that takes quite awhile.  Is there
faster way to dump a vb Private Type array into a SQL 7 table ?  I am
creating the table so if I need to change the names of the ...

I use VB6 + ADO2.7 to insert data into a database in SQL server:
When I look in the tables, I see difference between the time stamp I gave
and the actual values.
Please advise.

Hi everyone...
   I'm trying to figure out how to write a SQL statement that will select
records within a specified date range.  I've looked through the help offered
in visual studio 6 but nothing seems to work.  Could someone give me an

Just wondered which is faster for retreiving data

Is there any example or web site where I can find how to run a ADO Recordset
Query in VB-6 and fill the MSHFlex Grid Async using Multi Threading ?
Best Regards,
Luqman

I am in the process of converting a VB program to backend MS SQL from
Access.  The program had used the DAO data control to communicate with
Access.  This program has many data controls (8-10) incorporated into it.
Switching over to the ADO control is moving along but I have ...

Is there any way to excecute a sql script after the installation of a .net
application?

Is it possible to have a query searching through two tables?
I have a table called IR and a table called DeletedIR.
DeletedIR is the table which houses records which were deleted from the IR
table (they are identical of fields).

I get some strange behavior using ADO 2.7 (under VB6) with an ODBC
driver pointing a DB2 (UDB v8.1) database... In fact, I get some huge
time response (about 10 times the expected one !).
Investigation :

I believe (rightly or wrongly) that DataGrid is more
suited to recordsets, but FlexGrid is more versatile -
through code.
Does anyone have any further comments to make?

Hi.  I have a front-end (forms, reports, etc.) and a back-end (tables only)
MDB.  I already have the tables linked, but I want to be able to move my
back-end and re-link all the tables to the correct back-end MDB.
Can ADO do this or do I need to use ADOX?

Hello, I'd like to create a Jet 4.0 (Access 2000) MDB database from scratch
from a database I've already created in Access 2000 (with relationships!)
This means I need a program that can generate VB6 code.  I'd like to make
any changes in Access and just re-generate the code when ...

I use a ADODB.recordset but if I use the command
rs.recordcount it returns the value of -1.
Is this not possible in ADO?
Regards