VB Forum / Database Access / March 2005

I am using Visual Basic 6.0 and Access 2000. I'm trying to simply cause
an append query in my Access table to execute. Here is the code I'm
using:
  Dim cnn As ADODB.Connection

 I'm working with MS CRM and created a new Web Application that can be
accessed from CRM.  The web machine is called ECRM and the SQL Server
is on another machine called ESQL.  When running the web application
from ECRM it is running fine, when trying to access the web application

I found a mdac 2.8 bug.
I am using Windows 2000 SP3, VB6 SP5 and SQL Server 2000 SP3.
I select a table with a field of money type. If the field value is a large
negative value

Hopefully someone can give me a hand with this, I've run out of ideas
to fix this error and I haven't found much info online regarding the
issue.
I have a procedure that runs through a listview and for each row in the

I am trying to build a form in which I can get the team roster of baseball
teams by looking up the team name.  I have a combo box populated by adodc1
with the team name (from the table "Teams") and I am trying to populate a
list, text or data grid control by looking up the records ...

I am using VB 6 and Access97.
I need to do the following job. I need the ability to create cross tabs
on the fly while in VB6. The important thing is that I must control
which column is first and where the total column is. What columm lands

If I want to call the same stored procedure several times - each time
replacing the parameters, do I need to delete the parameters
collection between each call?
Example - After I do this:

I am trying to build a form with either a grid or listbox control which will
be populated with the items from field a, but only those records for whom
field b matches the item selected in a combo box or data combo from another
table.  The DB is Jet, and although this is no ...

I have a program I am writing that connects to a database with hundreds of
records.  When a user opens the program that pick a checklist name that they
want to update.  This is the part where I am stuck.  How can I filter the
records within my dataset to only show records I ...

Can anyone tell me the proper syntax for executing a JRO RepairDatabase
command for a database that has security using an .mdw? I'm getting and
error "Class not registered".  Here's what I'm working with thus far:
'**********************

I have 2 recordsets from 2 tables.
For example:
tableJob has colN(john, mary, ken), colID(1, 2, 3), colType(A, B, C)
tableQuery has colID(1, 2, 3), colX(11, 3, 9), colY(3, 8, 16)

Executing of that code does nor write any data to phone.dat file becuase.....?
Option Explicit
Dim gperson As PersonInfo
Dim gFilenum As Integer

I have an Access database running on Windows XP which seems to have a
corrupted VBA environment, but I can't seem to get a handle on what's
gone wrong.  Any pointers would be appreciated.
The system has Office XP (2002) with Office SP3 installed running on a

Hi, I am writing an app in VB. I need SQL and so I am using Jet 4.0
In short, I am having trouble with an SQL query that involves data of
type BINARY in the WHERE statement.
Here's a resume. To show you my point pls download the small sample

I have an application formed of two mdb: one «front» mdb for Forms, Queries,
Macros and Modules and the other «back» mdb for data.  I work with attached
tables.  
I want to compact both databases on closing.  I have set the option «compact