VB Forum / Database Access / May 2005

I can easily display the contents of an Access table using a VSFlexGrid DAO/RDO
control and an ordinary data control, but is it possible to update the database
table too?

someone's done something to the odbc setup on this pc that I'm on. When
i try to set up a connection to sql server i get the old type of
GUI/interface when i set up the connection (ie just the one window, no
forward or back buttons for other options).

I know that its possible to open one datareader at a time.
But my application is running on web, several users will access the
database at a time.
Is there any other way than the datareader in ASP.NET to fetch the data

The problem is that while opening MS Access database via ADO/Jet4 with
connection mode set to adModeShareDenyWrite, this should
prevent others from opening in write mode. But it denies writing all
(including me)! Adding adModeWrite allows to write but doesn't prevent

CREATE TABLE [dbo].[stuff] (
[c1] [char] (10)
)
insert into stuff values ('a')

I am having a problem reading the OUTPUT and RETURN parameter values from a
SP that I am executing from within VB.NET using the COM ADODB.dll.
Here is my code sample...
           cmd = New ADODB.Command

Hi friends
I'm looking for code tha export data from a worksheet to another located in
a closed workbook.
Thanks

If I create a DataEnvironment command by inserting a table from the data
view into the enironment, then I see the data records nicely on the
generated report. The problem is that if I use a SQL statement (SELECT
Table1.* Table2..* FROM Table1, Table2 WHERE (Table1.IDRec > 0)) ...

I am trying to write an all-purpose record changes sub when dataset mdsDS is passed in.  I am stuck at the very last step which is to grab the original and current values for columns (fields) whose values are different.  Can someone help me with the syntax for the old and new ...

There is a datagrid, bound to a dataset:
Dim PartnerAdapter As Odbc.OdbcDataAdapter
Dim dataset As New DataSet
(...)

Anyone know how to use OpenRowset
between 2 NON-LINKED SQL Servers?
tons of examples for LINKED servers, with access, excel, etc.
none for nonlinked (it must be too easy? no examples needed?)

Can  someboy post some best practices with ADO?? Do you know some website?
Thanks!

HI people,
I have a VB application with DAO and i am migrating it to ADO. In this
application, first of all, I connect to database and I open a ado recordset
for each table in database.

In the following code, the PayRS is a record set from a new (MS Access 2k)
database.  The Field (Currency)  "payment1" has no data in it yet. (If i step
through the code and rest the cursor over "PayRS!payment1", it displays
"PayRS!Payment1 = Null"

How do I detect whether or not a user has Microsoft Jet Database Engine v4.0
insalled on their system at runtime? On at least a Windows ME machine, the
presence of msjet40.dll does not tell anything. On that system (clean
install), that file exists, but MS Jet Database Engine v4 ...