VB Forum / Database Access / August 2004

hi...
I just curios, is there any difference between "rs.close" and "set rs =
nothing"?
Which one to you use?

I am trying to run command that uses the adParamOutput.  The return value is
always return nothing.  Here is the code for the running the command (it does
connect, the aCon is correct, I know that it is running the stored procedure,
because the stored procedure runs another that ...

Im having a problem in ado. I've made a function that will autonumber the records. When you press the add button button the itemno field will automatically increment. Here is the function I've made:
Function autoadd()
Dim add As Integer
Dim toadd As String

I come from a mostly web application background, but am currently working on
a desktop app to be designed using VB.NET.  The app will have around 15
users; I don't expect that amount to increase significantly.
I'm trying to decide on which approach to use in regards to database

How can I update a table in another database?
What I need to do is take the data in an Excel spreadsheet and insert it
into another database via ADO.
I remember seeing something like this using DAO, where the target table and

I have an application using VB 6 and SQL server 2000.
The Database server is in the office, and people use the Vb program from
workstation in the office, in otherwords it's running in a LAN.
Now, the company want to move DB server to outside Data center.

I get this error when I enter a non-date value in a
datagrid column bound to a date field of a recordset and
move to the next column:
"Multiple-step operation generated errors. Check each

I'm having a problem with a query using a wildcard on an Access DB.
This is my query:
SELECT * FROM Cities WHERE Name LIKE 'Amster*'
I also tried the SQL standard: ... LIKE 'Amster%'

Why does the exception (An unhandled exception of
type 'System.ArgumentNullException' occurred in
system.data.dll
Additional information: Value cannot be null.)

In am running Access 2000 and want to write some Visual Basic code to read
and write from a table which is not open (active in anty form).
I have used the commands:
   Dim tab_name As String

Dear Friends,
We have old DOS files whose structure I do not know. I would like to write a
sort of data coverter which will convert these files into SQL Tables.
However I need to scrutinize those files with a tool or a code. I tried to

I am using ado to delete records in related tables (somewhat like a
cascade delete) in an oracle database from an Access97 app and
wrapping these deletions in transactions.
As part of the deletion process I need to get some max and min date

I have a sub populating a collection class from a stored procedure
called via a dataenvironment command. On the first pass this returns a
recordset exactly as required. On calling this again to re-populate I
get the error 'Run-time error '3704': Operation is not allowed when

I am currently writing an deadlock handler for our application (a COM
DLL calling a SQL Server 2000 database.)
Having searched both ADO and SQL Server references, I believe that the
correct means to catch this error is to iterate through the "Errors"

Win 98 SE
VB 6.0 (SP6)
Hi,
I am doing an application that is capable of printing one-page