VB Forum / Database Access / December 2003

Hi, I have questions on ado batch update for sql server. I don't understand
why the example of microsoft itself can't work. I have authorized the user
all of the rights for the table to be operated. Here is the programme:
Public Sub UpdateBatchX()

I'm trying to open an Access 2000 database with VB6 so
that
I can modify the tables.  To make changes to the database
objects requires a specific User ID.  I am opening the

Where is the best resource to go on the net in order to find somebody that
will convert an idea of mine to a useable program?
Thanks

How does one pool a connection object?  I have the same application running
on 4 different machines, all connecting to the same server/SQL Server 2000
instance for DB activity.
Some posts have mentioned pooling the connection objects to reduce overhead,

I have been trying to modify Access 2000 tables using VB6,
but my tables don't allow most users to add/delete
fields.  How can I temporarily change the permissions on a
table or go in as a different user to make changes to the

I hope this time i have post in the Correct Newsgroup
In the previous posting, some newsgroup member reply
saying that I have posted in the wrong user group.
and setup a connection to a database(Access 2K).

I would like to drop all rows in a table at the database level and can't seem to do it through the ADOdc
"Truncate Table <tablename>" does not work

I have a Point-of-sale application that uses SQL Server2000 for the backend.
Basically, the users perform various functions boiling down to login (check
password from a table) and data entry (insert a food entry).  Previously, I
would open a new ADO 2.7 connection to the database ...

Can someone tell me how to avoid the system msg that says,
" Empty row cannot be inserted. row must have atleast one
value set. "
User get this message when they move beyond the end of

now i design a object persistence framework. i hope the O/R mapping class is
a pure data class. so the class needn't implement any interface and do not
care for anything outside.
it mostly like this:

Can anyone help me please??!!
I am using ADO having an adodc1 linked to Access XP Database (SQL Statement)
in a VB6 project, I want to search for specific records and display the
result in a grid. when I open the form all records are displayed in the

Hopefully someone out there can help me, I'm fairly new to the ADO
connection method and need a little help.
I have an MS Access Database (2000 format) and I'm using VB6 with an
ADO connection, the problem I have is when I use a different PC the

I've stored a .tif file in a image type field in SQL2000.
When I retrieve it in a recordset and try to set a
picturebox using that recordset, I get an error 'object
required'.  Can someone provide so assistance as to the

I am trying to get the average of a particular field for
several records in a database.  Some of the records are
blank and need to be excluded from the calculation.  The
following code works part of the time.  The rest of the

I'm trying to loop through a recordset and add the field name and
field value to a dictionary object.
However, when I turn on Option Explicit, the line marked with an arrow
gives me an "Invalid Use Of Property" error.