VB Forum / Database Access / July 2004

So far I have been using DAO in my VB programs. And I must say, I really
like DAO. But because of the better connectivity to other databases, and the
inevitability of VB.NET it's time to convert to ADO.
Has anyone been there? I'm just wondering of how much code change will be

I'm trying to create a function that I can use to change the SQL for a query
stored in an MS Access database. I was trying to use the following (code
below) but the adCat.Views doesn't list all of my queries so I sometimes get
an error saying the object wasn't found. It doesn't seem ...

Last resort, hi all
Have been using VB 6 to view and print reports using the crystl32.ocx
control from Crystal Reports 6. I have no problems with coding. I now use
Crystal Reports 10 but cant figure out the code to view and print crystal

how much records a table could store? if I store records to 2 or 3
even more tables, the database engine could have a "Parallel
search"?(I'm sorry my english is so poor) which means that search
engine to search multi tables in the same time, could it do that?

I use vb6.0  ( It was Updated with Mdac(tr) ,jet(tr) and Replication(tr) )
I have simular this SQL string in my code. ....Where Name Like '" & Text1 & "%'...
If Text1 = " i " or " İ " then found 9 record ( it is working properly in desing )
When i make exe this app.

I have a VB6/ADO application in which I currently use CSV files for specific
input and output streams. Are the processes/tools that would allow me to use
XML files instead of the CSV files?
Wayne

I have a hosted sql server database on my web site.
When I log into the server, I get a huge list of databases back, but
naturally, they've assigned my database as the default db - so that's all I
can actually view.

I am trying to execute multiple SQL Statement in one Connection.Execute
Method
Such as
Dim sSQL as String

I have a remote SQL Server 7.0 DB, (VB6 & ADO 2.8), everything runs great
except a 10 Million record table .
When I try to open a recordset like this
Dim stCnn as Strinng

POSTED IN
microsoft.public.vb.database.ado  
microsoft.public.vb.database.dao  
microsoft.public.vb.general.discussion

I ca use the followiung to find a record in a named field
SearchPatten = "MasterPINForeName like '" & searchtxt & "*' or MasterPINSurName  like '" & searchtxt & "*' or SecondaryMasterPINForeName  like '" & searchtxt & "*' or SecondaryMasterPINSurName  like '" & searchtxt & "*' or ...

Can someone please tell me why I am getting the "Object Variable Not Set"
error whehnj I get to the line "TableObject.MoveFirst". I am connecting to
an ACT! 6.0 db
Sub GetActData()

I am new to database and ado.  I learn to connect to my sql database
with this vbscript code.
set rs = Server.CreateObject("ADODB.recordSet")
sql = "select cust_name from tbl_customers"

Hi, I am trying to make an application onVB.net, the version in VB6 worked
fine, but I cant just upgrade it cause it was using DataEnvironment (i was
told it cant be upgraded). so now im writing a new App (with new features).
The point is, i try to drag the table to the form (as ...

I have a VB5 front end application to an Access 97 database.
I need to upgrade the database to Access 2000, and to VB6.
Is this likeley to be a relatively painless operation?
More importantly, should I leave DAO behind and take on ADO?