VB Forum / Database Access / February 2004

Hi, I am using VB 6.0, connecting to a Microsoft Access 2000 database
I used the report designer to create a report generated form the mentioned database
When I configure the connection string, and the other properties at design time and then run the report it works fine
Problem is ...

I've ssen some examples  here for how to insert a text file to a DB table
But I need a code example of how to retrieve
Scenario
I have a column in my Access DB defined as OLE OBJECT which I inserted text files into using Access

I installed this app on more then 20 win2k servers and everything was just
fine on all of them.
Now, there is this one server that reports the "Error loading dll" when
application tries to create object from com+ component.

Can anyone tell me if there's a shortcut to doing this?
Currently I have 2 databases, 1 in foxpro and 1 in MySQL.
What I have to do is to update/insert MySQL server with the data in the
foxpro tables.

I need help writing a SQL statement that returns the name & score of
the male and female who have scored the most points.
The data looks like this:
ID    Date     Gender     Points     Name

Hello.  I have Windows XP and I have SQL Server 2000 Developer edition installed, as well as Visual Basic 6, Visual Studio.net Enterprise Developer, and Office XP Developer installed.  I'm using VB6 and have been using an Access database with my application, and now I'm learning ...

I am trying to add some belts and braces coding to clear up connection handling on some spaghetti code that's been around for years
How can I programmatically close all ado objects without explicitly naming them? I can't seem to find a connections object to loop around..
Any ideas ...

Hi! all,
I need you help very badly, i need to convert some PDF files to work
document. I need to do it with VB, so a small application need to be
created. Does somedody has some idea how to do it. Please help me.

OK, I have looked a the books online, I gone thru 3 different VB books here
at work and I'm lost. Here's all I trying to do:
I have a text field '20030927'
I have a SQL Server 2K table with a field called apod_date defined as

Sorry about the cross-post but it seems relevant to both groups.
I have discovered an error when creating a user DSN using the
SQLConfigDataSource API while the XP style controls are active using
InitCommonControls and the Manifest file.

Hi *.*
For an accounting system I need to be able to filter the data that have a
code like "___9_3" or "_2__6_7%" or ... means user can filter data the way
he needs! So I need to use _ as a wildcard and I know ADO doesn't support

This isn't as much a plea for help as an interesting problem. Some of you
puzzle solvers may enjoy it.
Imagine if you will a table with three fields;
   PrimaryID

 I'm converting a project from DAO to ADO.  It works in DAO.  I have
the following new ADO code:
   testdb.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
     "Data Source=" & App.path & "\Test.mdb;"

How can I COPY all data from rs to a Dbase IV database "newdb.dbf" with
index using VB ???

anybody can tell where I could get the MS ActiveX ADO 2.7 dll from ? MDAC or
Service Pack ?...and where can i download it.
Thank you very much