VB Forum / Database Access / May 2006

I am using VB.NET.
I just created a form where user enters information.  Once information is
entered, user clicks ok button.
While updating the table, I am getting an error and it does not update.  I

<<Sorry to cross-post - I don't know which is the most appropriate group>>
It seems to be quite a usual problem but even with extensive googling, I
couldn't find any solution. Here is my irritating problem :
I have

Is there a way to get the sum of all records previous to the current
record, all returned within a single result query in Jet4.0 SQL?
i.e.
SELECT [ID], (SELECT SUM([Amount]) FROM [T1] WHERE [ADDED]=TRUE AND

I'd like to use SQLServer Express 2005 for a backend to a VB6 project (that
I do not wish to upgrade to .Net, at least not at this time). I'm
particularly concerned about deployment. Are there any good links on how to
create a seamless install of SQLExpress at the same time as ...

I am moving from MSDE to SqlServer Express and am having an issue with the
connection string for accessing a database.  What I am attempting to achieve
is a connection string that will work on any local machine so that the
application can function as a stand alone app.  I realize ...

First recordset sets the records to the array.
arr = rst.GetRows
Second recordset also has records, with the same columns, add to the array.
Arr = ?

HI, I'm having problems when execute a SQL statement in a Oracle table that
include a CLOB field.  I'm using VB 6.0 and MDAC 2.5.  The statement is
"Select * FROM MyTbale".
Thanks

Customer details are displayed in a windows forms where the data is
from SQL2000 server. Each customer has a record number. I do not want
to delete this customer from the database but made inactive.
I would like the details of the customer greyed out on the windows

In vb.net, I have set up a connection to a SQL server using the
sqldataadapter, a SQLconnection, a dataset, and a datagrid to display the
dataset.  When I display the grid, the DateTime field in the grid only shows
the date.  How do I get it to display both the date and time?

In vb.net, I have set up a connection to a SQL server using the
sqldataadapter, a SQLconnection, a dataset, and a datagrid to display the
dataset.  When I display the grid, the DateTime field in the grid only shows
the date.  How do I get it to display both the date and time?

I am trying to add some fucntionality to a suite of macros in Excel, which
requires me to call a stored procedure in an Oracle 9i database. The
signature for the SP is
validate_user(uid IN VARCHAR2, uid_ok OUT VARCHAR2)

Below is code I have to loop though a recordset and output Access
reports to snapshot files to be emailed by another application.  The
code works,  but is very slow.  When tested on 14 records in the
recordset it takes 16minutes to complete.   Any ideas on how this could

How is it possible to link a table located in a different access mdb through
code? Can it be done using normal SQL or with ADOX? Are there any examples
available?
Thanks,

Here's what I have but i'm getting and error when trying to open the
recordset: "object variable or block variable not set"
here's my code, I checked it many times what is wrong?:
Dim myFile, sqlstr As String

I've been tearing my hair out as I cant seem to get this working,
here's whats going on.......
I have an access database with several tables in it. I also have a csv
file that I would like to import in to one of the tables. I can