VB Forum / Database Access / April 2004

I build an application in VB6 that connects to a access db useing
MSADODC component. And it works fine on my developint notebook.
When trying to run the app exe on windows 2000 (not for developers) I
receive the following error: "Component 'MSADODC.OCX or one of its

I'm trying to convert a VFP table to Access using ADOX.  For some reason the
ODBC connection string always fails.  This is the code (VFP) commented where
it fails.
Any ideas?

--Table
Create table tableName (Field1 int, Field2 int)
Table Data
Field1           Field2

Ok - Newbie question on my part but any help would be great..
Using Access & VB to maintain a SQL server 2000 DB.  Here are the
basics;
Documents (pdf's, word docs, excel...) are streamed into the DB as

VB6
ADO 2.7
SQL-SERVER 2000 db
How can I setup a stored procedure to accept multiple values for a single

I am developing an invoicing application, and would like to know the most
efficient way to add a product selection into a DataGrid. DataGrid only
displays the following fields : Quantity, Product Name, Unit Price
As the program stands, the user will select the "Add Product" option, ...

I want to write the program in VB.
It is if the table named as "Customer"  is checked for existence in the
access database and if exist, then rename it , otherwise, nothing done.
What the code should be in VB 6.0?

I get this "Run-Time error '13': Type Mismatch" when I run the sample
code below. The debugger highlight the line "Set
MSHFlexGrid1.DataSource = rs"
Any ideas? I am using VB6.

is it possible to have more than one table open at a time??

Which databases can I use with VB?
Thanks in advance,
Stefan

I get this "Run-Time error '13': Type Mismatch" when I run the sample code
below. The debugger highlight the line "Set MSHFlexGrid1.DataSource = rs"
Any ideas? I am using VB6.
Thanks,

Could anyone help me with this problem please? I have a date time picker
control on a form, and wanted to use the find method or sql statement to
select records for the month picked in the control.
Example: A user selects the date 4/25/2004, I want the recordset to return

I hope someone can help me with this.  I've got some asp code that
grabs data from an MS Access database.  I keep getting the dreaded
'Invalid Use of Null" error, with the line number of the problem
pointing to my "movenext" line.  The offending code snipet is below.

I have a database with a  number of unknown table's
I don't know the name of the table's.
I like to read the name of the table's so i can open them.
The  idea is that i like to make a new table in a database is it doen't

I have a VB5 front end for an Access 97 database.  I've been advised only to
open the db when necessary, so I wrote a public function for this:
Public Function openmydb()
Dim ws As Workspace