VB Forum / Database Access / September 2003

Is there any way, using DAO, to get the index of a field
by specifying the field name?  Such a straightforward
question should have a very simple answer, but it just
isn't within my grasp right now.

I have a DAO control (:<Data1>) for a database with a
table(:<Table>) that contain two text fields (:<field1> and <field2>)
and the code:
Dim r As DAO.Recordset

I encounter this error when i try to open the Project References in the VB
6.0
"Error accessing system registry". Any help.
Venkatesh

whats the best way to filter a recordset on All fields in all records?
Thanks,
Denis

I have a problem trying to use disconnected recordsets.
here is my code:
   cnContacts.CursorLocation = adUseClient
   cnContacts.Open cnContacts

I have two strange problems with DBF structure file. Here
is a source code:
Dim lConnection As ADODB.Connection
Dim MyRS As ADODB.Recordset

I have the following code:
dim goConn as new adodb.connection
dim oRs as new adodb.recordset
goConn.open "dsn=xxx"

I need to insert 6000000 rows from one table in a DB to another table in
another DB, both DB are on the same server instance and both table have the
same structure (fields, index, PK, etc)
What is the faster way for doing this considering that I have not too much

I have to open a Access database from a VB application.

I've never programmed in VB.
I have created some forms in Access, and have heard that it is not too
difficult to incorporate these forms into a VB program.
Any advice or links to tutorials would be greatly appreciated!

I want to insert data from an Excelsheet into a Access
Database (which I use for my VB programm).
I want to start Excel without seeing the programm, then
insert the Excelsheet row by row into fields in my

I would like to do the following:  Create a new Access DB through Visual
Basic Code, which is password protected for read/write access as well as
encrypted. I know this can be done, I just don't know how to do it.  I
presently can create a new Access DB through Visual Basic Code ...

Hello...
I need some help with my SQL syntax, so it account for
all international date formats.  For example, if you set
your region to Germany (germany), the short date format

I was wondering what is the best way to handle a SQL
Server timeout?
Catch a SQLException, wait a random amount of seconds and
then call the same procedure recursively until a

Somenthing wnet wrong so I resubmit my question.
I'm using VB.net and have the following problem:
I've created a dataadapter usibng the wizard withe the following
sql-command: