VB Forum / Database Access / June 2007

I want my VB 6 app to send an array of data to a Word document.
I think the idea is that I create a Word template with mail merge fields in
it (OK so far??) and then I call this word doc, populate the doc and show
it - is this possible?

Hello to you all.
I want to select records from TABELA and put the result in TABELB.
I thought the query should be:
Update TABELB SET BEDRAG=SELECT SUM(BEDRAG) FROM TABELA.

I have a nice application (in VB6) that uses an ACCESS-Database.
Now there must other (always ready) existing applications use this
database and thatswhy it will converting into a SYBASE-Database.
My Problem is: how to use the SYBASE-Database in my program ? (I've

i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the

I'm trying to alter my stored procedure to take a parameter for the
Database Name, but as usual the syntax is killing me.
Thanks for any help
Dennis

Does anyone know How to programmatically set references for an mdb file,
using VB.NET??
any kind of suggestion will be helpful
Regards,

Possibly this is slightly OT as I'm using C++/MFC/VS2005 and Carlos
Antollini's classes from CodeProject
(http://www.codeproject.com/database/caaadoxclass.asp) to create a table and
index fields.  However, whether it's VB or C++, I think the clarification

I tried to backup my *.mdb to another drive but was unable to. Message
displayed was that database is opened exclusively by another user. My
prog. is a standalone so only one user.
How do I make sure all connections to the tables (recordsets) are

When I try to "print preview" a report based
on a table, I find myself faced with a "The
"SELECT" statement includes a reserved word
or argument name that is misspelled or

In trying to run the following "INSERT" query in
Access 2000, I keep getting a "type Mismatch" error,
probably due to to my trying to directly add, then
subtract the two "SiteOn/SiteOff" fields, which are

Does anyone know how to use Express Edition to compare value from a text box
that user entered to a database in access?
Simple like login....
In access we can use DLookUp but in VB we dont have that kind of function

I am using OleDbDataAdapter in order to fill a data table and update it.
The fill method is working fine but the update does not work, and I dont
know why.
Here is my code:

I've played around a little in here but basically what I need to do is
create an access mdb file with recordsets and fields using ADO. I'm really
after template code to define the statements and process to use. Or  a good
website which will do this for me.

Hi Again,
Either sorting the fields as in the post "sorting table columns (fields)",
OR, can I explicitly refer to a column when inserting a row or adding data.
Probably an SQL question really but I'm not very experienced using SQL.

Can show me what I'm doing wrong?
This works
strSQL = strSQL & " and tblacctcenter > " & """0""" & "and
tblacctcenter < " & """10111"""