VB Forum / Database Access / October 2003

I have a recordset in which sometimes I have to duplicate
some of its records. Is there anyway I can do this without
having to assign the values one by one. This recordset
contains all of the fields of the table it is linked to. I

I use:
VB 6 sp5
Access 2000 database
DAO connection

I am trying to import records from a csv textfile to an access 2000
database from VB6.  My SQL INSERT statement below works fine if the
date and time fields are removed. With the date and time fields I get
a Syntax Error when trying to import. Any suggestions?

I am writing a VB application that connects to a SQL
server 2000 database via ADO.
Upon the user clicking the save button, I want to save
information into 2 tables.  However I need the ID number

I was wondering if someone ever ran into a problem with retrieving
dates using ADO from an oracle database.
I have a website on a server running IIS, and using ADO to connect to
an oracle 8.1 database located on a remote server. The site was

is there someone who can help me?
I want to call an access(2000) stored procedure through vb6. How can I do
it?

in a access-database you can add some description-informations to a
table-field.
is it possible to see / access those description-informations in vb (ado,
dao)

I've got a store procedure that returns an XML using FOR XML EXPLICIT.
How could I get the results in a VB string?  Running the store
procedure in Query analyser give me a nicely formatted XML, but I'm
getting garbage using ADO recordsets in VB.  ADO streams didn't help

Are there somehow any ado.net dsrivers for clipper?

I'm trying to delete a number of records via an SQL.  
However, when I go to Refresh the Adodc I get an error
message that says 'Not allowed when operation is closed.'
However...it successfully deletes all the records.

Hi, how can I connect in a MySql And Postgre using Ado.net ?

Adding VB-code to Microsoft Access 2002 (10,4302,4219)SP-2,
problems with reference to a combobox on a form: (How to add a space
into a name?)
Debug, locals:   - : Item 1 :  : Variant/Object/Combobox

I have a thread which moved on to the second page of this
newgroup yesterday.
Unfortunately I can't move to the second page.  Instead
of the second page, the frame instead shows "Newsgroup

hey all..
i've written some code (slightly modified from microsofts official example
of how to use ADO prepared statements) that behaves differently under debug,
and im wondering why:

I have successfully created a table in an existing Access
table using the shown code.  My problem is that when
specifying not to allow zero length for the primary key,
the "Required" property also gets set to No.  How can I