VB Forum / Database Access / July 2006

Through a VB application, I have to run a program on an AS 400.
The program takes 6 parameters.  The first 5 are input and the 6th is an
output parameter.
I guess I would do something like:

What is the correct way to open an Access database with user security? I
can't seem to get the connect string right in the OpenDatabase method. The
database has a a UserID =DBAdmin and no password.
Thanks

I have two recordsets from two databases, both recordsets have identical
fields.
Is there some way to extract a new recordset from each that contains a
subset of the records based on a WHERE clause without going back to the

I'm looking for a way to search for multiple words in a database.
There is however one but. The words have to be within a certain range
of each other.
For example I would like to find records which contain the word MALE

I have a long date field that stores Date like "6/14/2006 11:30:00 AM"
I would like to query this field as short date... like
ssql = "Select DateX from TableY where DateX between 6/14/2006 and
6/15/2006"

I am very new wid VB6. I am trying to read .cpp , .h files in vb6 and
trying to get information from it. is dere any way to do it?
Thnaks a bunch.

I am very new wid VB6. I am trying to read .cpp , .h files in vb6 and
trying to get information from it. is dere any way to do it?
Thnaks a bunch.

Hey guys!!
I created a database using the built in SQL Express that comes with Visual
Basic Express.
I created the tables and relationships for now and I want to start testing

I have an many SQL Script that has a series of inserts, updates, selects. I
want to be able to run execute it from VB or VB.net. Any idea how can i go
about this?
the sql script is the same script that i execute in Query analyser

I get following error from my ADO code
"[Sybase][ODBC Driver][Adaptive Server Anywhere]Cannot convert 7/24/2006
4:05:07 PM to a timestamp"
My sybase table has column with data type "timestamp"

Does anyone have code that creates a table using ADO? I'm just looking to
create a table with int32, datatime and index. Any code on this.
Also, is there any code that will query a database whether a specific table
exists or not?

The following simple piece of code breaks at 'End' reporting error "The
instruction at '...' referenced memory at '...'. The memory could not be
'written'. Click OK to terminate the program":
Private Sub Command1_Click()

I have a Visual Studio 2003 .NET 1.1 project that refers to types from
ADODB like:
CommandTypeEnum, DataTypeEnum and ParameterDirectionEnum
and declares variables and parameters of these types.

I have problems with a VB6 program written by others a lot of years ago:
it's quite slow, but it has always worked.
For each employee in the database, the program reads data from other related
tables using command (MyDE.MyCommand FirstParam, SecondParam,...), then it

When connecting to a SQL Server 2005 table from home [1.5mb DSL)
[Me.TechnicalDocsTableAdapter.Fill(Me.Technical_DocumentsDataSet.TechDocs)]
it takes 5 minutes before I see any data.  The sad thing is there are
only 1,700 records in this table.  Granted, one field is a defined as