VB Forum / Database Access / March 2005

I am currently going through a "Teach Yourself" series for VB6. I've started
doing a little bit with ADO and would like to know what is the best way to
handle multiple forms that would access the same database.
If I add the ADO to form1 and setup controls, that works fine. But ...

I have just started in VB6.
I want to have a look at a complete Project - No matter how small it is -,
which connects with a SQL Server through ADO, Calls some Stored Procedure
etc, and if possible should be using a dynamic SQL string to fetch data from

Can date be calculated with comparison symbols as:
Date1 > Date2
Date1 <> Date2
Date1 = Date2

Is there a way in VB to delete an msaccess object like a table?
Thanks.

Is there anyway to access MySQL database with ADO? A driver?
Any link to documentation about this thema will be appreciated.
Thanks
Nhan

I need your help because its driving me mad!!
I'm querying an Access 2000 DB and although it is a straightforward 'fetch
all', I try to multi-sort it into my preferred set, but it only does half
the sort.  For example, my current query attempt is:

I need your help because its driving me mad!!
I'm querying an Access 2000 DB and although it is a straightforward 'fetch
all', I try to multi-sort it into my preferred set, but it only does half
the sort.  For example, my current query attempt is:

Hope someone can help me with this.
I have MS SQL 2000 database where i have Table "PriceList" and there a
column "Pricemk" wich is data type "money". All data in this column is
in form "10001,35". So why when i run .asp page with simple query to

Is there a way to find the size of scrollbars on a system using Visual Basic
6.0?
I know how to look and change them on the display properties, but I don't
know how to access that information from within Visual Basic.

I'd like to get some information about the different options to store and
manage connection strings to be used by a VB 6.0 application in a secure way.
Any idea or good article?
Thanks a lot

Re VB 6.0 & Access 97
I am using the MS Data Control on a form which I need to refresh each time
the user enters criteria. The DB is secured via an MDW file.
Could someone please provide an example, using DAO, with a solution to

All,
if this has been asked before, my apologies...
I have a function in VB6 that generates data that needs to go into a SQL
Server table. The data that is generated needs to be INSERTed into the table

Salve
Ho usato sino ad oggi il VB5 e vorrei passare ora a vb.net iniziando da zero
con nuovi programmi e non cercando di trascrivere i vecchi.
Mi consigliate un manule, libro o corso ecc per imparare bene tenendo conto

I am looking for the way on how to import data from excel file into SQL
server.
I found there is someone post similiar question before but the post was
expired.

Hopefully someone can help me.
I'm adding a record to a table and returning the newly created ID
(key) field value.
I'm Using vb6 & Access 2000 table