VB Forum / Database Access / November 2003

Our app allows users to open up records in a table with their unique ID.  At
any given time, multiple users may have a recordset open that contains all
their records.  These recordsets are opened using optimistic locking.
We are trying to figure out a way to let an administrator ...

I'm having a problem I hoped someone might be good enough to help me with..
I am writing a vb application which stores a reasonably large xml string (100K+ characters) in a text field in SQL Server 2000.  Inserting the record works fine.  When I try to delete or update the record ...

I have a VB 6.0 app running fine on Windows 98/2000/XP.
It uses mdac2.7, and msjet40 to talk to Access database.
I installed it on a Windows NT 4.0 workstation with
administrative privileges. When I try to run the program

Im building severall apps for a company in vb.net. Most of these app's
are database app's wich use access databases for data.
My quistion is if there is a simpel way of adding database changes to
the comtumers database. In other words, when I add a field to a table

i'm trying to make a program and in whant to make one
oledbconnection and use it in many forms whitin the
project. is this possible. when yes: how?
When a user clicks on my program and have select a

I want to create an adodb.recordset which uses a stored
proc. So I created an adodb.command (qy) and an
adodb.recordset(rs). After setting up the command I
create the recordset via SET rs = qy.execute. This works

I'm working on an image gallery. Is there any (preferably pure asp) way for
me to upload an image to an Access Db? Using GetChunk maybe, to load it and
it's partner, whatever it is?
Angus Lepper

I have several applications developed in VB 6, store my database in Access 2000 and use Crystal Reports 8.0
I have always built my reports from queries in my Access database and then use VB to dynamically recreate those queries each time the report is called in VB.  I'm using ...

Hi..
Need some help here...
I have problem inserting and updating to my date field in mysql.
What I'm need to do is to extract out the date field from a dbf table and

How do I set a Record object to the current record in a recordset?
Here's what I'm attempting to do;
Private Sub cmdGetRec_Click()
 Dim rec As ADODB.Record

I have some command buttons and i want to change them in french and
english caption as the user choice. How can i do thorough using table.
Thanks in advance
Tejpreet

Good day all.
Help is need here. I've been getting this error every now and then. 1 minute its working, 1 minute its not working.
Runtime Error '-2147217887'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

I have been searching for the answer to this problem and trying a number of
different techniques.  I haven't been able to figure out quite why this code
snippet isn't work.
with rsInteractions             'this is my recordset that holds the field

I want to know if it is Ok to install English version of MDAC
to a different language version of Windows operating system such
as Chinese Windows, since I want to view the error messages that
MDAC reported in English.  Can anyone give me any hint?

I have created a VB 6 application that uses an access 97 database.
There are a couple of things I would like to know about.
1) Can the setup and deployment wizard include a database file such
that when the user installs the program the database will also be