VB Forum / Database Access / December 2004

i am developing a bank application in vb 6 and sql server.
i have 2 tables. one is LoanPayment and Other is LoanReceived
when bank gives any loan to customer it is saved in LoanPayment Table with
its name and deal no{deal no changes from customer to customer i.e suppose

I'm using SQL Server 2000, and I'm having a slight problem with a recordset
from a stored procedure. When the query is first opened all settings indicate
that the recordset is editable. As soon as I try to add/Modify a record I get
the following error:

I've posted a couple of times about a speed problem I've been having
with one VB+SQL Server app. I can see what is happening, but I have no
idea why. I open a recordset (adOpenStatic, adLockReadOnly). That
search typically takes about 1 second. If I open another form where

Alright folks, this is something i've done a few times before, and I think
i'm suffering from analysis paralysis ... so some fresh eyes' would be
appreciated.  What i'm trying to do is run a query, take the resulting
ADO.Recordset and save it as an xml file.  This is what i'm doing ...

   Table Oelsls contains all products bought (history) table Invt contains
the products to sell (Inventory) I'm trying with no success to list all
products in Oelsls table (field name in both tables: part_id) that are not
in the Invt table.

I create a recordset as follows
Dim adoprimaryRS as ADODB.recordset
Set adoprimaryRs = New ADODB.Recordset
adoprimaryRs.CursorLocation = adUseClient

Hi, the following code writes garbage to a SQL Server database, can
someone tell me why? It writes the correct number of bytes but the bytes
are garbage. As far as I can tell this code is basically cut and paste
from the ADO2.7 help file.

I am an old VB6 programmer, and we have recently gone to VB.NET.  I am struggling to duplicate some of the things I had done in VB5 and VB6 to the new language.
What I need to do is to use VB.NET code to :
#1:  Open an MS Access database
#2:  Retrieve the data from one of the tables ...

I ahve an MS Access 2000 DB.  I am trying to create a table from within VBA
code.  I have done this before using the DoCmd.RunQuery command, but this
query is larger that 256 characters so I can not use the RunQuery command.
This is what I have so far:

I am using VB 6.
I have this old code that uses DA0. Recently we upgraded to Access
2002. The old VB code uses DA0. Seems that DA0 does not recognize the
latest version of Access.

of I am creating a program(in Access) for work that essentially calculates
various charges and displays them on a form.
A couple charges are time-performance based. e.g. As a rental company, we
agree to deliver the goods within 3.5 hours. If our delivery time exceeds

I'm curious to know what others feel is the best VB6 database book out there
that demonstrates real-world examples using ADO and multipel forms along
with datagrid controls, etc.
Opinions?

Hello.  I am using vb6 to retrieve data from stored proc.  It uses 2 input
params that are supplied by 2 text boxes on the form.  They are supplied as
dates to the procedure, since the query pulls the data based on the 2 dates
entered by the user.  My error occurs when the the ...

when I open an ado-connection from a dsn that is linked to an MS Access
database and I use the openSchema method (adSchemaPrimaryKeys), I've
got the following error (-2146825037):"
Exception occured in ADODB.Connection, Object or provider is not

<< Presumably you're using code similar to what's in
http://support.microsoft.com/?id=210132 >>
Right!
<< objAccess.OpenCurrentDatabase strDBName, False, True, ";pwd=xxxxx"