VB Forum / Database Access / July 2005

I'm using an adodc in a VB6.0 application but I don't know how I can set
this control to forced to be customisable ?
I explain : this control is using a DSN connection in order to connect to a
SQL database. But this connection is coded in hard in the program.

I have used the data control ib VB 6 a few times to read, update, display,
etc. records in a database. I'm new to VB .net and cannot find the same
control.
Please help.

Using VB 6.0, I have made a simple query of a database.
I would like to display the value of a specific field, using a variable for
the field name.
For instance.  If the recordset is "DBRec", and the field name is "Name"

Using VB 6, Access 2000, ADO 2.8, ADOX
Linking a table (Access) to another Access database in code using ADOX
Running a query against linked table, through ADO
Getting an error saying "No Read Permission" records cannot be read (on

While iterating over the stored procedures in the ADOX catalog
collection of the current project, I notice that not all of my stored
queries appear in the list - more frustratingly, the one that I need to
retrieve does not appear in the collection, even though it has been

I have been programming in microsoft access for years.  I have to convert
onew of my MS Access 2000 applications to Visual Basic.  I purchased visual
Studio .NET and it was recommended that it will be easier to conver to Bisual
Basic 6 so I purchased Visual Studio 6.

I use ADO 6.0 controls for developing a little program running on MSDE
or SQL server.
Sometimes my customers already have a SQL server installed so I need to
create my database under their servers.

Is it possible to add controls to a data report design at runtime?
I did not find any ADD method and arrays of controls are not possible.
Additional, I have some formatting problems.
1. With format string "d hh:NN.ss" the report always shows "30" when the

Hi, I have been using a VB6 appication for several years connecting to a
.mdb database. Recently I upgraded my MS Office from 2002 to 2003 now I get
"invalid data source" errors etc. I am assuming it is something to do with
the "enhanced" security. Can anybody point me in the ...

My problem is as follows:
I have a dll that receive data, and updates the database, by simple
adodb.connection and recordset.
I make "create object" to this dll from an simple exe.

I want to change my access database to use another mdw file because we
have a security problem in the file we are using today. Of course I can
change the security in the file we are using today but if our customer
saves an old mdw file they will still be able to use that one and ...

Good Afternoon Everyone;
My question is dealing more with VBA in Excel, however I could not find
enough information in Excel groups.
This is my question: I want to pull data from a huge database, let's

We have a ETL tool called Sagent using VB code. While opening the Sagent
design studio, We got this error message: "Can't quit at this time.". Not
Able to Open the sagent Design studio.

I have a program written in VB 6.0 that uses an Access database. The project
reference is set to "Microsoft DAO 3.6 Object Library" which I assume is
DAO360.dll. However, when the program is run it is using DAO350.dll. Is there
a way to force the program to use the 3.6 version or ...

Hello friends,
My name is Manoj, now working in MS-EXCEL 2003.
I used comboBox, textbox in excel sheet(1).
Now from comboBox selection I have to transfer that selection in