VB Forum / Database Access / January 2005

I need to make a database for monday in VB. It has to be a .dat file as we
are not allowed to use access.
The database has to be able to store Artist name, List of Albums, photos,
artist info, then when you click on an artists album, the album cover has

I have some VB6 code using ADO 2.5 running on a Windows 2003 Server box that
sometimes fails when trying to update an ADO field type of adLongVarChar
(stored as a text column in a SQL Server 2000 database, 6.5 compatiblity
mode) and produces the following error:

Using the schema.ini file for a CSV file I need to
retrieve all records via SQL using the date field within
the CSV file. All other data formats I can handle but
cannot get the SQL to handle the date format.

i am new to the vb and i found various methods to use ms access with vb,
which is best and stable one? and i heard that access97 is best to use with
the vb, is it true. in vb i found " dataenvironment" to connect to database!
how good it is when compare to hard coding for ...

I'm trying to get the input from txt1 to run a query, then display the output
in txt2.  I posted a question on 12/29/2004 (how to capture the text in a
textbox...), and here's the answer I got:
Set sdoRs = sdoConn.Execute("SELECT mslink AS msl FROM slope WHERE slope_num

Hi, when I call BeginTrans(gConnection.BeginTrans), sometimes get the
following error:
err.Number
-2147168237

I'd like to have a program like Query Analyzer but written in VB. Is
there such a beast?
-John

how can we edit the field of Access table from vb6?
i want to change a field of Access Table from non indexed to indexed (Repeat
OK) from vb code.

I want a combo box to auto-complete.  As the user types, if they only know
the first few letters, when they have typed what they know, I'd like the
combo box to drop down and show the content relevent to what they have typed
(similar to Windows Help Index boxes). Can it be done in ...

I have a number of databases that I use on a regular basis. Each one
has several processes that have to run. The code is stored in VB
modules. There is a lot of deleting records, running SQL statements,
and opening and closing recordsets going on before each program is

I'm developing a program with VB 6.0 and SQL server 2000. I'm using ADO 2.7
for data connection. There is one table that has over 40,000 records and
these records are for yearly inventory information. When I tried to add
records for new year through program. I faced a time out ...

ADO "NumericSscale" property returns 255 no matter what I set the
DecimalPlaces field property to in Access.
Using DAO I can get the right value.
Has microsoft confirmed this as a bug in ADO?

I am able to access Oracle package procedures just fine from VB and I can
also access package functions just fine as long as the do not have any input
parameters. How do I do this if they have input parameters.
This code works fine:

Using VB6 with an access DB.
I have an access DB with a Numeric field.
The "DecimalPlaces" is set to 2.
I try to get that value using "NumericScale" field property but it always

I am trying to store/retrieve pictures (bmp,jpeg,etc.) as fields in a
database record. Other than GetChunk/AppendChunk is there a way to directly
assign the picture to/from a database field to a picture control?
Thanks