VB Forum / Database Access / September 2005

Ok here goes.
I'm writing a VB 6 program that connects to FoxPro 6.  On one form I have 3
ADO's pulling information from the same DB and some same, some different
tables.  I have 2 datagrids connected to 2 of the three ADO's that are on the

I would like to ADD, RENAME and DELETE COLUMNS In Excel using ADO.
I am using ADO 2.7
I have used the following code for delete column..
conConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;

I am attempting to connect to Sybase ASE 12.5 from Excel using ADO and
VBA code. I see a lot of connection string examples that say use
various drivers (see connection examples below).
My question(s) are.

I'm doing an application with VB 6. Need to create a module or a class to
access the MS Access database that I'm using. So that I can use the methods
in that class to access and manipulate the database.
Please let me know of any material which may help me to get this done.

I have an application that uses a simple ADO connection to a local SQL
Access installation.  The problem is that the login is refused.  When I
logon using the Access GUI I use:
D76S0581\TPSVCCTR01

I've written an databae app in VB6. I used Microsoft ActiveX Data Objects 2.7
Library in Reference. Otherwise my VB6 IDE has only version 2.5 of MDAC.
The PDW adds this mdac_typ.exe (2.5 version!!!) and msado27.tlb type library
files to the install package.

I'm relatively new to databases and ado and VB6 so I would appreciate any
feedback anyone can give me on this before I head off down a blind alley!
I have an access database that contains a list of suppliers and a list of
products.  Each of these is in its own table.  I have ...

Any good sites to take me thru importing an excel spreadsheet into a
recordset?
Thanks

Can any one help me with this?  I have a recordset created in VB6 using ADO
that i want to export into a new spreadsheet.  I have looked on  the net and
Im struggling to find anything.  Can someone either help me out or at least
point me towards some helpful web sites?

I use a command object in VB.Net to pass the contents of an "Image" SQL
column, in a way similar to the code below.
This won't work in VB6 with ADO 2.8: .Execute throws an error

I'm working with a vb6 applicaiton which is inserting with ADO some data in
a SQL Server table.
Through VB6, the connection runs well, but not the insertion.
The SQL Server 2000 is installed on a Windows 2003 Server.

I have two recordset R1 and R2
I want to display  all the items in R1 wtih Values in R2 filtered out
Whats the simplestest way instead of iterating R1 and R2.
Say R1 has values 1,2,3,4,5,6

I am looking for an example to bind a text box to a database field and have a
save button to save the updated information back to the database.
This is what I have tried so far. But it doesn't work.  
   Private Const Connection As String =

Hello Friends
I have a question
supose we have 2 access databases one is in our computer and the other is in
the internet.

I am running a VB6 Application on a SQL Server 2000 DB backend.
I call a stored procedure that returns results to my recordset.
The error I keep getting is that when I want to set the AbsolutePage
property of the recordset I get "