VB Forum / Database Access / February 2004

When I try to Rollback a transaction using Access & ADO, the underlying data
is correct, but what I see on the screen is not, and results in the old
"Cannot locate..." errors if you try to change anything..
How do I get this to work properly automatically. Calling Requery will not

I'm trying to extract data from an Oracle 8 db into an Adodb.recordset to be
used in a FlexGrid in VB6.
One of the fields in the Oracle db is of the LONG datatype. The field only
contains characterdata which typically is between 200 and 300 characters

Hi, we have a companion program to another company's major app, and we have our own little Access database with our own tables and some Linked ODBC tables imported over from that company's database (they're using SQL Server).  Anyway, when we install our utility programs at ...

I need to allow multiple users to get into the same Access database at the
same time accross a network.
The system will be importing and exporting data in the background as 4 or 5
users work with it.

Is MS-Access XP (2002) incompatible with Visual Basic 6?  If so, is there a
workaround?  Or do I need an older database program to interface with a VB6
application?

I have the following code in VB which is working perfectly:
--------------------------------------------
VB Code:
--------------------------------------------

I don't know whether this question has already been answered... I couldn't
find anything about it. Let me get straight to the point.
To retrieve a list of procedures available to a given user I use the
OpenSchema method of an ADO Connection object and it works fine. I simple

VB 6, MS SQL server 2000, odbc, ADODB
When I use VB to create Temp Table, no error prompted. But I got no
TempTable in tempdb database, can someone find out the reason?
my VB code:

Hi I currently have a problem with opening any database using the following
code
Set DbsSettings = DBEngine.OpenDatabase(App.Path &
"\databases\settings.mdb")

Hi all..
I have a problem which I have been trying to figure out for the past 2 days.
I'm currently developing a program in VB 6, connecting to MySQL database.
What happens is that when i tried executing a SQL statement from VB

I have a continuing issue with Visual Basic. I am displaying data in a Data
Grid from a View that I have created in the Data Environment. I add a record
to the underlying table. How do I get the grid to reflect the changed data?
In other words, how do I get the view to update, and ...

I have a table with an orig_date_time field and a term_date_time field.
This table contains records that are based on when emails come into and out
of agents inboxes.
I am trying to calculate the agents service level. To do this I need to

hi,
i'm working with VB6 and Oracle and keep getting a "Multiple-step OLE
DB operation generated errors Oracle" error trying to access a field
in Oracle of type LONG, here is the loop i'm using:

I've goto an adodc control, tied to an Access 2000 database, and I change
its recordsource on the fly.  I use an sql statement, and sometimes some of
the data used in the where statement will have an apostrophe in it.  Like
this:

I developed a small program in which I save the users comments and suggestions into access database.
Every thing is working fine when the user types what they want inside the textbox and they can save it, but when they try to type this character ' and then save it the error came ...