VB Forum / Database Access / January 2006

Just wanted to gauge some thoughts of other professionals....
I have a fairly big VB6 project using an Access Database and the way I have
set it up is that I have the following components:
- A standard project (for forms)

I'm trying to write the contents of an Access table to a CSV file,
which I can do easy enough. But I need to include the field
descriptions too, I understand this can be done using ADOX?
I've had a google and can't find much, I wondered if anyone could point

Hi, Team
In VB6 whitin a form,  two text box are there.
I want to save these TextBox values within excel-sheet.
and i want save with password.

Hi I have to emulate this Oracle PL\SQL block in VB6 using ADO and ODBC
driver
DECALRE
temp NUMBER;

Working my way through some existing code I have come across this:
If Me![First_Run] = "N" Then
    GoTo first_filter
End If

   Can someone post a working example of an update query run against a
FoxPro 6 table?  Or tell me what's wrong with my code listed below?  I keep
getting an error message telling me that there's an unrecognized phrase or
keyword when I run this query.  stNew is a user defined ...

I want to create a project but i am not sure how i  go about it.
What i wasnt to do sounds simple, but with me being a hardware guy i need a
little help
All i want to do is:

How cound i get values from listbox (which is already filled) to
textbox in VB6

I have a program that was developed originally for single-user use and we
are now trying to modify it to allow multi-user.  We need to be able to
perform record locking, and everything that we have read would indicate that
the .LDB file will take care of that automatically (with the ...

i'm using the following to connect to an MS access database; however this
will not work when connecting to OPenOffice database file. Is it possilbe to
connect using this driver method:
Set cnnNWind = Application.CreateObject("ADODB.Connection")

We have an applicaiton that is structured as follows:
There is a VB 6 ActiveX.exe that maintains an ADO connection object.
There are several client VB6.EXE's that use this ActiveX EXE to connect to
our database server through interface calls. The ActiveX object returns

i've got a database in access 2002. i'm creating a vb program to acess this
database. i'm using adobc...
i;ve got the following peice of code, to add customers into the database,
but i get an error at 'RentalDatabase.Provider' line. saying object variable

I created a form which connects to a database.
With all the connection info on the form if works great.
When is move the connection stuff to a module and call it still works but,
when I try to call the record set in the form

How to retrive cursor created at Oracle database... can I get few examples?
Thanks
Nats

We have numerous apps in vb6.0 developed with Access and DAO. All work
great.
We're now moving up to VB6.0 SQL2005 and ADO.
In VB under Project there are References.  The list is big and are, in some