VB Forum / Database Access / August 2004

I am updating an SQL database using a VB front end App. Anyway, I am working
with CommitTrans and Rollbacktrans
In one of my update queries i am doing the following:
Set oConnect = New ADODB.Connection

Dear Friends,
Even though I am quite experienced in Access & VBA I new to VB.
I am trying to create a simple bound form using  Data Form Wizard. So far no
problem. Wizard does its best. But when I try to run the form that is

Greetings all,
This is a repost.  I had to put this down for a while, but now I have to
get it running.
I am using an Access Database to store question information for a

We are in the process to develop a new VB6/SQL 2000 application (do
not ask why not .net, our company policy is to use VB6), which will
have over 3000 users to access the database (50GB data) and perform
heavy add/update on one table. Without the privilege to have a

When attempting to invoke CopyRecord am getting the error
"either the source URL or the Parent of the destination URl does not exist"
they both do an work on other similar sites
can anyone explain the conditions where this error may be caused

I've been using VB6 for a few years now, and recently started database
programming (so I'm kinda a noob).  The one thing I keep reading over and
over is that you should use unbound controls in favor of bound controls.  Is
using the data control really that bad?  Are there certain ...

I am trying to create table from vsial basic using activex adodc object. But
for some reason I am getting error. This is what I have been trying.
sqlCreateTable = "Create Table report1 ( style char(15), colour char(15),
size char(15), count char(15) )"

Where in a sql database can i get:
1. a list of tables i created.
2. a list of all fields in each table.
3. the data type and size of each field.

Need a way to save an ado recordset into a table, without
looping through the recordset (too many records).
The destination table already exists, may or may not be in
same database.

I'm creating a hierarchical disconnected recordset. Cursorlocation is
adUseClient, LockType is adLockOptimistic and Options is adCmdText. So far
so good. But when I try to edit a field, I get an error that the recordset
cannot be updated because of a limitation of the provider or ...

Does anybody knows the connection string for an ado connection object
for reading a file *.dbf (DBase created).
many thanks in advance...
Miguel Martinez

I'm sure that this is a simple question....
I am exporting the top 6000 records from a table every month, i would
like to be able to set a field to say that i've exported those 6000
records, so that the next month i can filter those records out and

I created  a DHTML app using VB6.  My app is accesing the SQL server using
the following settings:
"Provider=SQLOLEDB;Server=Server1;Database=Northwind;UID=User1;PWD=Password1
"

I want to be able to have a button on a form that allows a user to
cancel a query (Access 2000) if it seems to be taking too long.
Any ideas?
Cheers

I need to write two VB apps and call one from the other. How can I program
these two that a code is returned to the caller from the inner app when its
calling(execution) is finished.
Any help would be greatly appreciated.