VB Forum / Database Access / December 2003

I've just got a few questions about VB and access 97.
We're in the process of revamping a lot of our databases
and procedures.  What I really need to know are the real
differences between a DAO Insert and A DAO Edit.

I have a reporting application that we use for four
different plants (or would like to).  It uses DAO 3.6 and
Crystal Reports 8.5, as well as access 97.
The application works fine, for all but on plant.  

Hi, I have created a dataset programmatically.
I want to be able to run sql statements on this if
possible, however I can't seem to get around the fact that
I have to set up a connection, problem is obviously I have

I need the dll to run the filesystem object yet when i go in to componets
and i search for it and i find it i hit apply and it says that it cant load
the object.
Please Help

I have two connections to diffrent database
I need to build a command that takes the data from one connection and place
it on the other connection
How can i do it?

I want to retrieve data from a master recordset to a child recordset
using either recordset's functions(if there are) or command object.
Thanks
Regards

I'm working with multiple recordsets (an array or recordsets, to be
specific). As I move from recordset to recordset in the array, I have no
problem setting the field values until I get to one particular recordset. In
one of the recordsets I get the following error when I try to set ...

I am trying to do a query Using ADODB to an DBF Table.
If I try it using a Date filter, there comes the next error
"ODBC driver does not support the requested properties"
This is the code I am using:

I need to know what is required on both the WinNT users
side and the SQL users side when using the following line
in my VB code to connect to my SQL database:
gobjConnection.ConnectionString =

Using VB.NET on XP and here is the code:
       Dim constr As String
       Dim qstr As String
       Dim conn As New OleDbConnection()

Real simple stuff, for some reason, not working!  The message returned
is:
"An exception of type 'unknown exception' was not handled."
...always the hardest to debug, those unknown exceptions... here is

I'm trying to connect to an Oracle 8.1.6 database using DAO. I keep getting
the error "3024- Couldn't find the file" and then a copy of the connection
string is shown.
My code is:

I'm currently writing a program that executes a Stored Procedure. This
SP contains only a stupid SELECT.
Problem: When I Save the results of the recordset to an XML file, the
state of my .EOF property changes!

ok here is the deal ,
i have a monthview control
and a file list (or listview if its what i need to use) and a image box
i have a fold named pictures with all my pictueres namde like this