VB Forum / Database Access / May 2006

I have the following function. I need to use RecordCount of the RecordSet
that is returned when the query is run, but I get the error : "Rowset does
not support fetching backward. "
Private Function CheckInDatabase(dteBirthDate As Date, arrPatientName() As

I am new to VB so my question might seem a little silly but it would be
great if I could get some help.
I have the following function in vb. I need to call this function from some
other place in the code. What should be the return type for this function?

Hey all,
I have a form with a Datagrid, a button, and a ADO connection.
The button is to add a new row (has defaults set).
If i go into a record, hit add a row then change some values, exit - go back

Recently moved to Arizona. Computer crashed, need to reinstall VB6
Professional, but cannot find original CDs. Microsoft no help. Any
ideas of where I might find reasonably priced installation CDs?
Thanks -- Nick

I have run a SQL statement with REPLACE function, i.e. UPDATE [ABC] set
param1 = replace(param1, "YY", "10") where metatag = "CELLV2", successfully
in MS Access Query. However, when i pass this SQL into Access through VB ,
it returned an error, "Undefined function 'replace' in ...

I have the following problem which works but, apparently, its very bad
programming practice.
- I create a table (Access) to store some calculation results because
they are too numerous for memory storage.

VS.NET 2003.
Using ADO.NET/Dataset method to do db update.
I may be wrong. From what I learned the DataSet method is a "Disconnected"
type of data access.

I use VB.NET 2003 & SQL Server 2005.
I will make it simple.
I have a winform which has a textbox "Member No".
When the user enters a value and click the Search button.

The same application will run on different computers, each one connecting to
the same Microsoft Access 97 database on a shared network drive. When the
application on ComputerA runs, it can connect to the database fine, but when
its connection is kept open, any connections to the ...

We currently have a number of VB6 applications connected to an Oracle 8
database which download records to a local database with no issues.
We are also in the process of upgrading to Oracle 10g. The application
still works but for some reason when reading a recordset it seems to

I was wondering why my posting never got a reply. I thought the folks at
Microsoft were suppossed to respond x amount of hours after a post was made
according to my MSDN subscription. Is this true. In case anyone was wondering
my posting was

Im building a program that queries a visual fox pro databases (free
table). The largest database has around 80k entries with around 100
fields in each. Also there are several users on this database using
visual fox pro.

I have the following problem which works but, apparently, its very bad
programming practice.
- I create a table (Access) to store some calculation results because
they are too numerous for memory storage.

From within my VB6 application, I am using ADOX to create a linked table in
an Access 2003 MDB to a text file.
The linking all works fine, however I want to be able to define the columns
for this text file.  If I only have field names in the text file, for

I wrote an application to maintain a small MySQL database. Connection is
through ODBC using ADO.
Occasionally I get an error [MySQL][ODBC 3.51
Driver][mysqld-5.0.19-standard]Lost connection to MySQL server during query