VB Forum / Database Access / September 2005

Can someone help? I'm trying to load a .csv file using the Microsoft Excel
2002 (10.6501.6735) SP3 engine in the below code. But on the .Open, I get a
"Couldn't find installable ISAM" runtime error in the design environment.
Might I be missing a reference? Or is something else ...

I know I can do it using the name property with adox but I can't do it using sql. "RENAME TABLE table TO table" and  "ALTER TABLE table TO table" do not work. Please help.

I'm trying to generate a table with VB 6 and ADO or DAO which contains
one field where the username of the network user is stored automatically
when a new record is added.
I tried to solve this by setting the defaultvalue-property of the field

I have a VB application hitting Access97 back-end database.  I wish to
convert db to Access2000.
Do i need to convert my VB app to use OLEDB Jet 4.0?  How do I get and
install 4.0 on my development machine?  How to I install on the user PC's?

Hey All,
I have been trying to implement drag and drop with data bound  list boxes .
Does any one know if its possible?  I have been getting just the data row
when ever I do the drag and drop or I have been getting the selected index

How to connect with My SQL? Can I connect with its database?

Is it possible to create a Sql Server database from a VB6 application via
DDL?   I've found the 'Create' method isn't supported by the OLE DB
providers for SQL Server.
Also, when working with SQL Server databases from a VB6 app., what specific

I have created 2 Stored procedures where one calls the other inside an
xp_sendmail call (see code below). When I exec ProcA from QueryAnalyzer I get
an error message "ODBC error 2812 (42000) Could not find stored procedure
'ProcB'." whcih is correct as ProcB is not defined in the ...

Please -- I am having difficulty passing parameters into a
StoredProcedure in an Oracle9 database.  This is my first experience
with Oracle, so my code might resemble the same process I already have
working with a SQLServer2000 database -- but I am lacking some basic

I'm writing a VB6 application that will contain a class. The class contains
a number of data driven methods and I will therefore need to use a connection
to the datasource. Is it best to pass a connection into the class, to create
a connection in the class_initialize event or to ...

I have been beating my head against the wall on this on.  I am trying
to delete all of the records in a table using the ADO control.  If I
issue a SQL command:
adodc1.Recordsource = "Delete * FROM myTable"

Using VB5...
I have a data widgets SSDBGrid.  The data grid is linked to a visual basic
data control which I have linked to a database table during design time.
When I click on a specific column head, I would like the grid to sort by

Can anyone provide some insight on preventing Access database bloat? I
am currently developing a VB6 application that uses ADO to interface
with an Access 2000 db, retrieve SQL statements stored in a table,
execute those SQL strings, publish the query results in Excel, update