VB Forum / Database Access / July 2005

Dear experts
I have quite a complex SQL statement on my vb6 form to link to an Access
data source
Instead oF going through the tedious task of writing it direct I constructed

I would like to know if it's possible to create a report in VB like the
one we create in Ms-Access.
Any suggestions?
Cheers!

We are using ADO to read a csv file into a record set. The VB connection we
are using:
connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Path &
";Extended Properties=""text; HDR=Yes; Format=Delimited"""

I am currently working with a Visual Basic 6 application and an 8.1.7 Oracle
database.  How do you change an expired password from Visual Basic to Oracle?
Oracle returns the "expired password" error to VB6, but I can not find any
documentation on how to update the expired ...

Hello friends ,
 i  have one prob, i  have one central database and other offices the
databse is in same format and  filed .How can i got the data from
othre offices and update it to main databse and also can track teh

We're finally making the move from Access 97 format to Access 2000 db's.
Is it possible to convert the database programatically (we're using vb6)?
Unfortunately, all my searches are bringing up pages on how to convert from
access to vb!

I am trying to open a recordset in a table to find the Recordcount whithout
briging the whole recordset down the vpn line it seems like the code i am
using is wrong ?
  Set RsSupplier = New ADODB.Recordset

Can anybody help me out with a problem? Is it possible to have a table which
has other tables as entries? For example, suppose the main table is called
table1. It contains two fields, a primary key field and another which
contains tables. The tables in these fields, also only ...

   Trying to put a NULL value in a Sql database field. The following code
snippet does not work
   Dim Sql As String
   Dim SQLDB As ADODB.Connection

Doing exercises from Gunderloy's 70-310 Book (Developing XML Web Services and
Server Components with Visual Basic .NET and the .NET Framework), I get a
Query Execution Error message box stating "No connection could be made
because the target machine actively refused it" on ...

I need to update some records from my application to a Visual FoxPro DBF
File.
I can read records from DBF File but when i try to update them a get this
message:

Hello --
In my VB code I need to set a variable to the sum of [Fee] (the last column
in each SELECT) from the following query.
SELECT CaseID_c, ContID_o, RevDriv_o, [# of subs], Fee

VB6 on XP SP2
The following code runs OK for most of the time but occasionally give a
'Cannot locate row for update' Error.
.movefirst

If you have a recordset (DAO or ADO) in vb/vba that points to a query
of joined tables. And you change one field (that exists in both tables)
ihow does it know which table to update.
Or how do you force it to update only one table???

We are running SQL server 2000 and have an older VB 6 app that uses RDO 2.0
to connect.  In general everything works just fine.  Recently, we've
localized this application and are now having some issues with the database.
Running standard SQL sentences and stored procedures is ...