VB Forum / Database Access / December 2004

 I can't get the expected result though the sort properties of MSHFlexGrid.
The following is my coding :
   With MSHFlexGrid1
       .Redraw = False

just a quick question: where can I download the ADO SDK?
I couldn't find it in the microsoft's website.

VB 6.0
I want to create a DBF in a VB DLL. What would be the best way to do it?

Hi, im trying to copi the information from a DB that i have in Access2003 to
another one that i have created by my own trough code in VB6, but when i put
de statement:
ConsultaAccion = "INSERT INTO [" & TablaDestino & "] " & _

I work with VB 6 and Sql Server
I want to export tables of SqlServer to Access97 with primary keys and
foreign key
thanks for the answer that can offer me

How do I convert an excell workbook to a textfile in VB
I need to do it cell by cell so I can manipulate thedata.
I assume this can be done using ADO?
Any examples would be usefull.

1st post here so................:-)
I am using VS.Net and coding in VB. I am following some examples from a book
that shows a connection string as:-
sqlcnn = new sqlconnection("data source=(local);initial

I am working in VB6. I'm migrating an application from DAO to ADO.
I need to trap ADO errors.
Is there a listing of DAO errors with their counterpart ADO error numbers?
Thanks in advance,

Could anyone tell me how to create one recordset which joins two tables in
different database in SQL Server?
Pls give me the sample codes.
Thanks,

I am reading an Excel spreadsheet into an ADO recordset using a Jet 4.0
OLEDB connection.  The problem I am experiencing is that if the recordset
columns are being created as type of 'double', even though some of the
values are mixed (numeric and non-numeric).

I'm calling a stored procedure from vb6 and passing like 29 parameters. I'm
trying to set a recordset to the results, but I always get an error that I
can't perform this operation while the record set is closed. I do not get
errors after executing the procedure and I have used ...

I have a problem running reports, which are stored in a Access2000 database.
1.) The database is secured by a database-passwort.
From VB6 i can log into the database, read and write data, but i fail to run
the stored reports in Access2000. How should be the syntax to get the

I routinely need to import some tables into Access 2003 from a fixed Excel
file. The Excel contain several sheets, which I all wonna to import to
Access. But the repeat-import is hineous, so any expert idea on how to build
a VBA sub to do this kind of job?

Could anyone help me to join table with different database for one recordset
??
How to build the connection in ADO??
Pls give me the sample code.

is there a way to let a VB program find out the IP adress  of the pc on
wiche the program is running and put the IP in a variable?
thanks 4 helpin me