VB Forum / Database Access / August 2006

I have a form which opens a recordset with
 db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=E:\My
Documents on E\Visual Basic\AMFI\amfitut.mdb;"
 Set adoPrimaryRS = New Recordset

I hope this is the right place to ask this question!.
I am trying to populate a list control with values from an MS Access query.  
(Query works fine in Access itself)
I have created an access query, and attempt to open it using ADO in my app,

I need to export a table from MSSQL server via script.
I have been trying all sorts of bcp solutions but I seem to get
nowhere. Once generated, the file cannot be opened as a DBF file.
Best solution for me would be to exec via bcp a stored procedure. Since

Hope my Title is appropriate
Table1
BrId      ProductCode      RowID
2    KT978                5

I have a recordset that I build myself by appending fields. Then I
populate the recordset with data. The data in the recordset are then
further modified, but I need to keep track of which row is modified,
against the initial data.

How can I make a copy, NOT a clone, of a recordset?
-Lou

Hello everyone! -
I am exremely new to ADO (Ver 2.8). I'm a DAO 3.6 from old school and I only have
I have 1 ADO book as a reference. I am not using an SQL server, or MySQL.
This is a subroutine of a larger program which is supposed to search a field, within

I am having some problems with Visual Basic 2005 Express Edition and
databases. I have tried three different pieces of code (one I made that
executes an INSERT command on a SQL database, another sample project from
Microsoft also using SQL, and finally one from VB 2005 EE for ...

Does anyone know of a way to parse a module in an Access 2003 database?
See i need to search through a module for specific code (string).
I know in VB you can simply run a textstream through the .bas file and call
it a day.

I am getting the above error when running a VBA application. The error
is returned from a stored procedure call. The stored procedure name is
called 'usp_storedprocname'. It works fine when directly called from
SQL Analyzer. It does contain SET NOCOUNT ON .

I am using VB6 with Access97.
In a QUERY in Access I have a field where HOURS are entered.
Through VB I can enter DATA based on a MEMBERS ID.
I am trying to SUM those HOURS to show in a COLUMN in my DBGRID or even a

Why or under what circumstance will the creation of a recordset give me a
"type mismatch"?
Here is the code snippet and the error occurs on the last line shown below:
Dim db_Control As ADODB.Connection

Not sure why this is so difficult.  Using VS2005/SQL2005, and have a
table that has changed.. God forbid, something changed!  I would like
to delete the dataset, but there must be some special secret to doing
this.  I can add a new dataset.... just can't delete one.  The

Is there a way from visual basic code that I can install a printer driver
for a new printer that being added to the system?
Thanks in advance for help with this!

In 1998 I was pretty much at the peak of my (very limited) programming
hobby.
I wrote a VB front end to handle a MS Access database of around 65,000
product lines.  This has been running on a Windows 98 machine since then