VB Forum / Database Access / August 2007

Could I get help clarifying the difference on cursorlocation aduseclient and
aduserserver.  Why would you use aduseclient.  I don't understand the
advantages of one over the other?
WB

Hello everyboy.
How can i convert a String variable with XML inside to Oracle BLOB
data type?
Inside the String variable there is some data fields in XML. I need

Can anyone please help me to solve this problem I have
when I tried to compile and run my program written in VB
6.0?
Problem: I used variable declaration such as db as

I am having a problem in reinstalling a VB6 application on WinXP/SP2. After
a successful installation I run the application and get error message:
"Run-time error '3447': The Jet VBA file (VBAJET.dll for 16-bit versions, or
VBAJET32.dll for 32-bit versions) failed to initialize ...

I have a VB6 application that uses an "Office 98"-vintage mdb database
file.
The application had no problems thru XP SP2 and most Vista quirks were
usually solved by setting the UAC/Administrator entries appropriately

I  would like to delete a single record, however the result of my code
is that the complete recordset is deleted
Can anyone help me out here????
Here is my code

Please any one in the world could help me exporting datareport to
excel or word and backing up the the datas in access database through
VB6

Hi want to create a new record within a Try Catch block using the
following code
Function Process() As Boolean
       Dim rsAttendance As New clsMSRecordSet

I have been programming in MS Access 2000 and am converting a program to VB6
and need some help. In Access we could place a subform on a form and have the
subform display all records from a table that match a certain criteria. I am
looking for a way to do the same thing in VB6 ...

Is there a way to insert a record at the top of a disconnected recordset
after it is retrieved from the database?
.
I know I could create a recordset, add the row, retrieve the data from the

Hi, I've been retired 5 years and let my skills get very rusty!
My son has asked me to write a database for his small company and I have VB6
(Enterprise) and Access 2002.
I'm getting on OK (I'd forgotten what a buzz you can get from doing this!!)

I recently inherited some VB6 code that uses the data control to access
and query an Access 2000 database file.  My PC is XP Professional with
SP2 but it has Access 2003, not Access 2000.  When I run the VB6
application from the executable created some time ago on another PC,

my server side VBScript code works fine and is as follows
dim con, param, sql
set con = Server.CreateObject("ADODB.Connection")
param = "Provider=sqloledb;Data Source=MYPC;User

Are there any known issues in using LIKE * in an SQL for ADO?

I've been using Delphi for years (Win 32) and connecting to my SQL Server
databases with no problem.
I am now trying to learn bth VB and C#. (Visual studio 2005)
From the Data menu, I select Add New Data Source