VB Forum / Database Access / March 2004

I'm coding a form use ADO 2.1
But when I update data into a Table (Microsoft Access 2000) I always receive
an error:
"Run time error -2147217888 (80040e20)"

On 2/26/04 Val Mazur kindly replied to a posting I made.
The following code was sugested:
Dim loCommand As ADODB.Command
Dim loParameter as ADODB.Parameter

I have written an app which reads an Excel spreadsheet and loads the data
into a spreadsheet. I establish a connection to the spreadsheet, open it,
and fill a dataset pretty much the same as if it were a database. For the
most part it works fine.

Using Visual Basic 6.0, how to retrieve the schema/structure of a
table i.e. datatype, NULL is allowed or not, size of the data etc of
any column ??
Thanks

Quick question on the above. When executing a CREATE TABLE statement using
Driver={Microsoft Visual FoxPro Driver};SourceType=DBF the tables are
created correctly. The problem is that they are created in the root of the
app running the code.

I am using  MS Visual Basic 6 to access pocket pc.  I want to check if a file (xxx.cdb) exists in pocket pc before further processing.  I've tried ceFindFirstFile, however, it doesn't work with a .cdb file.  How could I do that
Regards
Bett

i want to make paging via recordset but it doesnt work when i call stored procedure,but it works when execute sql sentence
i try to set recordset cursortype "static" but recordset take default value after execute and record count seems -1 so paging dont work.how can i do paging ...

I have a problem that I have spent an age on and can't resolve.
Basically, I have a table that has a date field. I have created SP's to
return values within a given date range.
The problem that I have is that when I append some data to the table,

Can anyone tell me if there is an easy way to add child records to a
table that is part of a hierarchical shape?
I have an Access database with 2 tables and have used the Data
Designer to append the child table to the Parent table so that it

Hey All,
I`ll Pay someone to tell me this now, as its doing my head in, I carn`t see
out on the net and no one seems to know!
I have a form that connects to a Access database, and I have a combo box on

So I was SELECTING (from an asp page) a date field from an oracle
database in which one of the values was 03/02/0004.  The query would
execute correctly.  However, when I used the returned recordset to
access that particular value, I kept getting an error:

I have an application that loads a word doc from a SQL Server
database, allows the user to manipulate, then when the user click a
toolbar item that I create as an add-in, the VB component inserts text
into the document and saves it back to the database.

I am trying to normalise a 'zoo' Acccess database.
The UnNormalised table has the following
ZooId (PK)
Animals

I'm curious to know if anyone has any code for making their own HTTP load
balancing service.

I am ussing Bulk Insert procedure but having problem to
insert when any column in a particular row has null values.
The issue is I know a numerical field column does not have
any value or null what can I do so that I can insert this