VB Forum / Database Access / June 2004

I am trying to populate system DSN in the list box using the following code.
Option explicit
Private Declare Function SQLGetConfigMode Lib "odbccp32.dll" (ByRef
pwConfigMode As Integer) As Long

If there is a more appropriate newsgroup to post this question to,
please point me in the right direction.  I'm using WinBatch, rather
than VB, but there are some similarities and I think the problem is an
ODBC one rather than a language one.

I have a problem similar to one I've found notices of elsewhere, but I
haven't yet been able to get around some annoying errors ado or jet is
giving me. I'm trying to use INSERT INTO from a temp database into a
password-protected database. I have tried a ton of minor syntax

I'm getting 'Record too large' error when trying to append columns using
ADOX for any table with > approx. 9 columns.
e.g.
DIM cat As ADOX.Catalog

I've written a VB application. I used the Microsoft ActiveX Data 2.7 Library
in Reference. The PDW created a package with MDAC_TYP.EXE to install
Microsoft Data Access Components on the target computer.
I'd like to deploy and install my application on Win95 too. Is MDAC compatible

I'm working on a project and i've an problem with filtering. I'm using
the 6.0 version of visual basic. I shall explain it. I've a dbgrid
connected with a data and the data is connected with an access
database. In the tabel is a date. So i wan too select a date in the

I am having some problems, basically I don't know how to to do the
following.
I have aMSflexgrid that loads data for a table. one of the columns I have
marked as a button, fo rthe drop down ability. can someone give me code that

I would like to save the values in a vb form to a worddoc.
So when i click the button a new wordfile is created and all
values of the fields on the form are transferred to word.
Is this possible?

I need work with Access database from VB6.
In my program I have subroutines for reading one table (only updating one
row) and for writing to another table (only adding records).
In another program I must work with this database only across ODBC. To table

I am using a data control with vb 5 connecting to an access 97
database.
I have set the DatabaseName and RecordSource properties at design
time.

I'm using VB6 to read/write data to an Access db.  It reads data fine, but if I try to write data where there are more than 509 characters, I get a runtime error 3421: Application uses a value of the wrong type for the current operation.
I'm using parameters to write the data:

I am trying to retrieve a Bitmap Image from Access 2000, stored as OLE
Object, into an Image Control via ADO.  My goal is to display the
bitmap image into an Image Control on a Microft Excel 10.0 User Form.
I have been trying this using VB6 and Excel and have had no luck so

List:
I've an access database that I've been opening from VBA.  The database
requires that the SystemDB property be set to a custom file.
I can open the database and read records from the VBA application.

Which reference should I include in VB6 so that this:
Dim ps As rdoPreparedStatement
makes sense?
http://support.microsoft.com/default.aspx?scid=kb;en-us;154756

Hi this is one question that has been nagging me ... I don't remember
the exact details anymore since I always forget to ask when it arises,
can someone set me straight on this?  Just as a quick example, if I do
the following: