VB Forum / Database Access / May 2004

I have some flakiness going on with some code ... getting crytic ODBC
errors on the DAO Update method.  I forgot to write the error number
down and can't seem to reproduce the error now.  But I want to put some
error checking in and dump out the error code next time it happens.  ...

Hello again
i have a textbox, connect to a ado datacontrol
if i change the textbox and after make
ado.recorset.update

When I select an item from a datalist by clicking on it, I would like
adodc moving to the current record selected on the datalist.
Please help.
Roro

Is it possible to use a control to display data in an existing MS Access
(lookup) table, then select a specific record and copy it to another table?
I don't want to manipulate the (lookup) table, just get data from it to add
to another table.

BlankHello,
  I have visual studio 6.0, I tried to open office2000 access database from VB program, I got error message. Somebody said I have to install sp5, I did, but I still can't open access database, but I can use office97 *.mdb files.
   What should I do? How can I use ...

I am writing a multi user program in VB 5 , using DAO 3.5 (Jet) and I have
the following problem.
Station A reads (method Seek) a record, station B reads the same record.
Station A changes the record ( methods Edit and Update), a little bit later

i recently upgraded to vb6 sp6. before (wit sp5) printing under win98 was no problem, but now (with same source) i get errors like overflow, automation error, unable to create object, etc..
project uses mdac2.8 to print data from a sql2000 databas
all updates are installed on the ...

I have a large and totally unbound VB 6 program that currently accesses an MS Access 2000 database using ADO.  I would like the program to be able to access either the Access database or SQL Server 2000 database
I know there are a few differences in the sql syntax and would like ...

Help!!!
Grrr...
Within a View class:

From VB 6.0 SP6 with all the appropriate references loaded
Access 10
Here's a code snipet
 Set acApp = CreateObject("Access.Application")

i want to write blob contents to a xml file
Private Function CreaFicheroTextIn(ByVal ExecutionId As String) As
Boolea
 Dim sQl As Strin

I have just started developing in VB.net 2003.  I want to us the OleDBDataAdapter.Update(dataset,tablename) method.  It work just fine with MS Sql Server 2000 but when I use the same code with Access, I get an "Syntax error in UPDATE statement".  Do I need to do something ...

In the results of my SHAPE command there are some child records with a
number in the Component field of the Yearly_Details table. This is
part of a composit key to another table. I would like my SHAPE command
to show me a count of only the records with a value of greater than 0

I need to see if a table exists in Access using ADO.  I
tried
"Select Name from MSysObjects Where Name = 'myTable'"
But I got an error message that I don't have permission to

I have a VB class which converts BLOB from Oracle DB to JPEG, BLOB is read from the DB directly and converted to JPEG image
In one of my applications, the BLOB image is automatically converted and passed as String. The BLOB size is 4 KB, So I'm pretty sure that string will not ...