VB Forum / Database Access / December 2003

I must be going potty on this!!!
I have a VB app > ADO > Access 2000 DB.
The below query works fine if I send it as a text query (I have left it in
below but commented it out and changed the Type to 4) and if I execute the

I'm using DAO 2.5/3.5 Compatibility Library reference and I'm accessing a
Access97 DB With JET 3.5 (No SP)
I'm developping on WinXP SP1 With MDAC 2.7 SP1.
All the controls in VB are binded on a DAO data control

I am using DAO, in a VB6 project with Access97. is there anyway to set the
Access 97 database, and open it from VB ie using opendatabase, and also
using data control
Can anyone help please

can someone tell me how to grab a value from a select statement using DAO
into a variable?
my table has RecordID, RecordNumber, Description
I want to grab the MAX number within the RecordNumber field and assign it to

How cane I change the Nullable properties when I append a
new field to a Access Table. Appending the new field I do
like following,
Dim gConn As New ADODB.Connection

i am using SQL Server 2000 - i want to return an ADO rs which i can scroll
in both directions and whose .AbsolutePosition and .RecordCount properties
return the proper values!
based on the reading i have done on the topic*, i have tried using Cursor

Moving a VB Date datatype to an ADO field (SQL Server type
SmallDateTime) resulted in:
The conversion from DateTime data type to SmallDateTime
data type resulted in a SmallDateTime overflow error.

Hi...
Im am developing an add/edit page with a shapped record set...let say ORDER
and ORDER DETAILS
When I Batch update(adding a new record)  the Order recordset works just

I tried the following method to insert date field into DBF table.. but I get
syntax error.....
whats wrong? can anyone help???!
MSQL = "INSERT INTO TRANM (TRAN_DATE) VALUES (" & Format$(dtTranDate,

I have vb.net and access but some file ocx don't works (they are file OLEDB:
ado, commondialog, dataview...).
Both .net and access tell me that i don't have the licence to use this ocx.
Why?

Guys,
Hopefully someone out there can help. I have spent at least 20 hours
trying to figure this out, with no luck. I am using ASP to pass data
into a VB component, which then passes the data into a stored proc in

I'm trying to extract data from two joined tables (Access tables). I'm
using a query like this:
"SELECT Table1.*, Table2.* FROM Table1 LEFT OUTER JOIN Table2 ON
(Table1.Field1=Table2.Field2 AND Table1.Field2 BETWEEN 10 AND 100 AND

I'm trying to open an Access 2000 database with VB6 so
that
I can modify the tables.  To make changes to the database
objects requires a specific User ID.  I am opening the

I have vb.net and access but some file ocx don't works (they are file OLEDB:
ado, commondialog, dataview...).
Both .net and access tell me that i don't have the licence to use this ocx.
Why?

I plan to have a LOT of SQL string in my app.  So I need your advice for
this.
Is it a good idea to store all my SQL string in the app.config file?
For a maintenance point of vue it would be easy to access and change any