VB Forum / Database Access / May 2004

I posted this in the VFP area but I think it may be more for this area
How do you access Visual FoxPro 8 files in VB 5 or 6.  The ODBC driver
do not seem to work so I downloaded a new vfpoledb.dll file.  It di
not help.  It seems I need to use OLE DB but I've never used it before

I frequently use the ISNULL function when querying a SQL database like this:
SELECT ISNULL(Title, '') From Contacts where ...
I need to do the same sort of thing when querying an Access database via the
MS Jet driver.

I have a program, currently in Access, and I'm migrating it to VB.
Option Compare Database
Option Explicit
   Dim filename As String

I have been struggling for at least 2 weeks on this one issue, maybe you can
help. The application that I am working on downloads Access DB Files from a
PDA. The file contains an OLE Object (This is actually a signature). I can
not for the life of me figure out how to move it from ...

I am having a time with syntax
strSQL = "select * from qryMast where " & _
           "tblInventory.SerialNo like  '*" & txtSerialNoSrch & "*'"
Can anyone tell me what I am doing wrong here?

How to change:
-DatabaseName
-RecordSource
of "Data" contol having only the path of database you want to open.

I'm using VB6 sp6 (Eng) on a Win Xp Pro ( eng ) machine with DAO 3.
I have a project on Access 97 that use DAO and standard DataControl and I need to convert i
to Access 2003
Compiling the project on IDE it seems to be OK, the program opens  the mdb correctly but running the .exe ...

Hi again.
I'm using an ADODB connection with a DSN.
Now, I want to replace the DSN for a Login Form, in which user inputthe
Server, DB name, Login and Password.

First, sorry for my bad english!
I must using a database that resides in a NT Server and my application
run on coputers that make part of another domain.
So, when I try to connect my app to db an error is raised.

Hi again.
I ahve investigating about GO command.
Into SQL help, says taht this command it's available on ODBC calls.
I am conecting with the Database using a DNS...

Can anyone help me out on how to determine what to set the cache size value at when using a client-side cursor
Any help would be greatly appreciated
Thanks in advance.

I have a vb6 app, mdac 2.8 sqlserver7
the problem is: the onerror will not trap the errors thrown by ADO on one
machine.
The error is expected, the statement is trying to delete some rows from a

I have a problem in returning data from multiple table as one table into
a dataset.
as we know that in dataset we can populate it with multiple tables, but
what if

Our VB6 application delivers a yyyy-mm-dd date to the MS-Access database.
If the day of the month exceeds 12, all is well, otherwise the date gets
changed to mm-dd-yy format (prefixed by the two century digits).
2004-05-03 becomes 2005-03-04 but 2004-05-13 remains unchanged.  Where ...

We plan to develop an archive of documents we've sent or received from
customers. We want to be able to list the documents related to the
customer and enable people to view a document using the associated
application.