VB Forum / Database Access / November 2004

I defined a recordset, can it auto detect the change other user made? How to
do that? Thanks...

I have a VB6 application that uses an access database and I am trying to
figure out the best way to distribute the package.  I have the following
references:
Microsoft ActiveX Data Objects 2.8 library

I have written a vb program that uses ADO. I use SQLOLEDB as a provider to
connect to a SQL server
All the prammeters are fine and the program works fine on my PC.
On my PC I have not setup any User DSN nor System DSN for the SQL

Greetings. I really appreciate the help. I am a newbie.
I am creating input parameters for passing values from MS Access to a stored
procedure.
I have several fields that are primarily time values. Would the type be

   I use JRO for compacting my Access database. Somebody knows, how can I
integrate a progressbar when the database it's compacting as Ms Access
environment does?
I try using a Timer, but no result,. because once it begin the compacting

I want to link a button to the data report.When i click this button, an
input box will pop-up asking me to input my data.For example: I want to
display a report for August. Then when i type in 8 in the input box. Then
it will display all the record of month august. Can anyone tell ...

I have a form with two textboxes on it txtA and txtB.  I am trying to use
the executenonquery() statement to run an update query and the result is
always double the number of records (ex if it updates 7, the value returned
by executenonquery() will be 14).  Below is exactly what I ...

Im running Vb6 (SP5) * SQL 2000
Im getting an error saying that the Stored procedure can not be found, i
have looked on the SQL server and have made sure that the DSN logon has full
rights to the Servers & the stored procedure

I am trying to create a string and I need an actual literal " in the
statement. I've tried multiple double quotes but still cannot get the syntax
correct.
Here is my statement:

I am looking for a very easy, reliable and secure way to send-only
information from a VB6 client application to a remote internet server. There
are no updates or deletes required – just add new (append). The receiving
server has not yet been defined, so there is some latitude ...

How can you tell if any of the statements below has succeeded?
Set cnn = New ADODB.Connection
Set cnn = CreateObject("ADODB.Connection")

Is there a way to copy the table structure from one mdb file to another.
Just as import data definition in access but programmatically.

I am working on a batch app which is using ADO to create records in a couple
of tables. The database is an Access 2000 db.
In one situation, I am inserting a record in a table that has a primary key
based on an "autonumber" field. Access handles the creation of this field

I want to confirm that I must use the server-sides and adOpenDynamic for
users can see any changes by another user when they are running the system at
the same time!
Thanks & Regards,

What is the syntax to use ADO with an Access 2000 database that also uses a
system file (.mdw)?
I have the following ...
dim strConn as string