VB Forum / Database Access / August 2004

I'm using a VB6 front end with a Microsoft Access mdb file.  I want to give
the mdb a password, and include this pasword in my connection string in the
code.  I'm not using an ODBC connection.  As far as I got were errors about
a missing installable ISAM...

I have a problem with an application. This application use a DB2/400
database. When the application try to connect to the database, I have
the following error message :
"Provider cannot be found. It may not be properly installed".

I have an application that I installed on XP and it says it's missing the
DAO drivers.  I can't seem to find anything like an old MDAC that I can
install that provides these drivers.  Any ideas where I can find it?

I have an Oracle database in which I have a column with datatype LONG. It
contains a (long) string. Everything is fine as long as only ASCII-7 bit
characters are in that string. As soon as the string contains some
characters in the 8-bit range (typically accented characters), I get ...

I was hopping some one can give me an explanation for this.
Stored Procedure: (All this is in one stored procedure but this is the basis
of what it does)
Step 1: I have a stored procedure that selects some records from tblTableOne

I am reading the database schema information for an access database using
visual basic. I get all the relevant information except the autonumber field.
I have a question as -
How to identify the Autonumber field of Access? similarly

What is the difference between Primary key and Unique Key ? From the
definition, they look like the same thing to me. Thanks.

I never tryed to connect to sql server in vb so i need help
the server is mysql5 and is insalled on a server on remote network and
i don't know how to make a connection to sql...
thanks

I have created a data form in VB6 with built in data form wizard and  a
access database with the help of data manager in-built VB6. The database
contains one table and table contains fields like Amount( type = text),
Date (type = date), Name(type= text).

using:: VB6 / MySQL
What is the best way to test a query before it is sent to the database? I
am making a program in which the query can/will be dramatically different
depending on what the user fills out on a form.

I have created an Access database frontend with Visual Basic and I am
expieriencing a problem.  When I open the program and run it
everything works fine the first time.  All of the records are present
in the database.  But after the first use, everytime I open the

I have a datagrid and I transfer the data to datagrid from database. And
then i want to find a record that is taken from text and show it in the
datagrid. So I used the "row" property of datagrid1
but there is poblem with this property. The error occurs "Run Time error

I have an application that I am writing it reads from a FoxPro table I want
to sort it by part of a field. What I do it I get an error. Here is the SQL
string.
   strSql = "select id_name, po, job_no, ref_no, npdate " & _

I have a access database with 250000 records in it.
I've created a vb appl that searches the db, if i want to search something
it taks 30 seconds to find it. (20 seconds to connect and 10 seconds to
search)

I have built an application in VB6 that incorporates an Access2000
database for data storage.  I am using the Package and Deployment Wizard
to build an installation program for the application.  However, during some
attempted installations the application generates the following ...