VB Forum / Database Access / May 2005

I use this instruction in a asp page to obtain a recordset:
"MyRs.Open strSql, MyConn, adOpenForwardOnly, adLockReadOnly, adCmdText"
but the Err object have this description:
"not valid type of arguments, not included in the allowed interval or in

I created a data form using the data form wizard and including only 3 out of
the 6 fields in a MDB file.
I know you can then add more fields later and bind them to controls using a
dialog in VB6 which has a SQL string in it.

I am using vb 6 and trying to open my access 2003 data base but it is not
reading this version of my data base whereas it reads version access 97
Question:
1- Why?

This statement always shows False for the result.  I would to test that
value to see if it is null.
If (IsNull(rsTextline("Text" & cstr(i))) Then

I am going to develop a Banking Solution for very small branches of a
Bank. The branches are standalone and no remote transactions will be
made i.e. only the individual branch will be under networking and there
will be no networking between the branches. The branches have maximum

This is more a generic question. I want to update a record with a
time/date value. There is a valid value already in the field, i want to
get rid of this value and replace it with a NULL or something to show
that there is no longer a time/date value with this record. I have

I am trying to connect to a Access MDB file, using ADO. The example I have
has the following steps:
1) Create an ADO data control and align it to the form
2) Browse the properties to set the Data Link file.

Two questions.
------------------------------------------------------
1 - I have a disconnected recordset that I want to delete all rows that have
myField = A

I select an item in a ListBox, scroll the ListBox so that the selected item
is not visible anymore and select another control. Now I press the Tab key
until my ListBox gets active again. However, the selected item is still not
visible.

This one of the tables
I want the text file to look like this:
-curve -p 185.123456,156.123456,68.123456 -p
175.123456,164.123456,70.123456;

I have the following bit of code.
This recordset has zero records in it at the beginning. I wish to add
records using the addnew method.
when I get to the addnew method it says the recordset does not support

I'm writing an app that front-ends to SQL Server 2000 Enterprise, and I'd
like the users to be able to choose which database they want to connect to.
I have most of the code already written, but one problem has been vexing me
for days.

I didn't mean to put Do While in there I was really tired.
The program was a mix of 5 different examples i've found.
I want "-curve -d -p column 1 in the row named X, a space column 2 in
the row named Y, a space column three in the row named Z all are

Can someone please help, before I go completely mad . . .
I've tried posting this on the Access.conversion group but nobody there
seems to have an answer.
I'm using VB6 and Replication Objects 2.6 to convert an Access 97

Aloha,
  I'm writing a desktop/Windows application using VB.net (MSDE
2003).I'm trying to use integrated security with a User Id and password
to connect to a SQL Server. The SQL Server administrators insist that I