VB Forum / Database Access / May 2007

I need to update the column value in many rows in SQL Server 2000 table.
I'm creating ADODB.Recordset, poulating it with data by using "SELECT
Balance FROM CheckRegister WHERE AccountID = " & lngAccountID
When I try to set a new value to Balance in the recordset I get an error

I have a tab-delimited text file (.dat file) created via sql server that I'm
attempting to parse in visual basic 6.0. I have tried Random, Sequential and
Binary file access. All to no avail. Finally, I had to parse the file by
retrieving the position of each tab in the file. That ...

Running Access 2002 under WinXP, all updates (including Jet) are in place.
This one is driving me nuts.  The table has over 1000 records.  But opening
an ADO.RECORDSET on CurrentProject.Connection returns no records!!  I have
written code like this hundreds of times and never ...

Dear Expert,
I want to use datagrid in my project , i have created one table in access
and also configured one of its field lookup for combobox and set Sql
Query.when i open table in access itslelf .i m  getting combobox for that

Using VB6 with DAO 3.6
I have a procedure in an Oracle database with 3 parameters (1 string & 2
dates)
I was given (something like) this to use in my VB program, but am having

I'm trying to import data into an Excel sheet with ADO.
I don't understand why the same query that in Access gets the correct
output when is called by Excel+ADO return no records!!
Everyone can tell me why and help me to solve the problem?

I am trying to execute Oracle stored procedure through VB.net application.
But when I execute cmdConnection.ExecuteNonQuery() I am getting following
error message. I have passed two input parameters and expecting two output
parameters values from stored procedure.

how do I calculate a date within a certain range like,
if today's date is within two weeks of a certain date.

I am working with VB.Net 2005 going to an Access 2003 database.
I want to give my user the ability to copy a list of Orders (based on MR #
and PreviousVisitDate) to a new VisitDate when they are creating one. I have
everything ready but I am stuck on how to construct an SQL ...

How do I use DAO to open an Access (2002) database which has a password?
The goal is to copy tables (with structure and data) from one Access
database to another.
So any other solution is appreciated.

I am developing ASP site using VB script.
I am trying to connect to MS Access 2.0 db using ADODB.Connection.
I have tried different providers as OLE DB, Jet Engine and ODBC => no
success, because the version of access is too old.

Dear expert,
I want to learn How to use treeview and listview in VB.Please give me sample
programe.and also tell how to bind to each other.
thanks!

I've created a client front end (VB6) for a database app connecting to an
Acess
2003 database.  I would like to get the "Caption" property from a table's
fields.  For some reason... i can't seem to find the option to grab it from

I have a database that I have been querying from my visual basic
program to take my access DB and convert it to excel.
I use a multitude of SQL queries to get it to the format I desire, but
i have a time column that has both the date and time within them. When

I have tranfered a Excel sheet in to a Flexgrid.
In the Excel sheet I have multiline Text .
How cane I get this Text  in the same manner in the Flexgrid.
Thank you for any advise