VB Forum / Database Access / April 2007

I have a puzzling issue.
I am receiving the compile error "Method or data member not found."
It's behaving erratically, and when you see the rest of my
explanation, you might see why.

I am hoping that someone has come accross this issue before and can
point me in the right direction for a suitable solution.
I have searched through google groups and tried everyting I could find
from old posts (to no avail) and also had a look through the microsoft

What equivalent of the MID(,,) vba expression can I use in a query against a
JET database?  I'm using VB6 and ADO 2.6.
I think that with DAO I might use this function; I know that with T-SQL
querying I'd use the subString(,,) function.

when i read some data from a excel-file via ado, then I can select the sheet
over the sheet name: "SELECT  * FROM [" + SheetName + "]". So I must know
the name of the sheet.
It is possible to read the data, when I don't know the name of the sheet?

Hola !!!
Deseo que me ayuden en una aplicación en VISUAL BASIC ASP .NET, tengo una
tabla
con 2 campos

I'm trying to access an access database on the file server from a web server
using asp.net and IIS 6.0.  I can do it when I have anonymous access enabled
in IIS 6.0 as in the public internet web site style.  I want to do the same
with the intranet setup where IIS 6.0 is not setup ...

I have been given the task of creating a process that writes details
to mainframe database tables via n ODBC link. Originally an attempt
was made using VB which worked for a few hours and then failed with
the following message in the log:

i read a excel-file via ado. It works fine, when text is in the cells. When
there is a integer-value (f.i. 1234), then I always get NULL. When I write
'1234 in the cell, then it works also.
My code is:

In this VB code,
Option Compare Database
'------------------------------------------------------------
' mcrEmailClosure

How do a do this in the vb side of my aspx form to add a new row in my table
when I create a xsd dataset.  I've searched with no luck.  See the the do it
by code after the do it by wizard.
Wizard Code

Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a
single query.  But, I can't seem to get it to work, even in an experiment in
Access 2K.

I was brought up with dBase, and now need advice on how to post linked
records using DAO & SQL. Though I could do a kludge for this, I want to know
to do this simply and efficiently.
I need to use DAO to post to a non-SQL system, where I calculate totals for

this is probably a general question, but urgent to me. please help.
Senario:
Access DB with a table of about 1 million records, with VB 6.0 + AdoDB
adoConn.execute " delete * from tableA where (colA=1 or colA=2 or colA=3 or

I have an insert statement in a function that I call repeatedly.
Let's say I call it 80 times and then there are 57 new records in my
table.
Presumably, the other 23 errored out for duplicate or other reasons.

Hola !!!
Deseo que me ayuden en una aplicación en VISUAL BASIC .NET, tengo una tabla
con 2 campos
nombre de la persona y un campo memo donde dijito una carta con formato