VB Forum / Database Access / December 2003

Hi Group,
I am using Access 2002 database to track component parts.  This database has
a parameter query named "Query PN".  Here is the text pasted from Access SQL
view.

I'd like to know the "Best practice" for store / retrieve images in a SQL
Server DB. I been using ADO streams to do this through a temporary file but
I'm searching another more direct way.
I will appreciate any suggestion.

Hi
## - Does access will limit - one user at the time to run
the report  or will  lock  the database ??
I am  running my first VB/Access database application on

Hi all..
How do I search for .zip files in a specific directory using VB codes?
Can anyone show me some sample codes for this pls?
Thanks.

I'd like to confirm if the ON DELETE CASCADE restriction only works in MSDE
2000 and not in MSDE 1.0. Is that correct?
Best regards.
--

1: How to get schema information of any database by using VB.NET. Is
there any library like SQL DMO for VB6.0

I tried to do something like this (m_cnn in my case is a
connection to a SQL Server)
   Dim cmd As New ADODB.Command
   Dim rs As ADODB.Recordset

I have recently installed a number of apps written in VB6 SP5 with ADO
2.6 clients, connection to SQL 2K SP3a on W2K SP4, on a mixture of
client workstations - mostly W2K but some XP SP1. SQL uses Windows
authentication.

In VB6 I wrote a simple app with a datagrid which is populated by an ADODB
recordset.
After population by an ADODB recordset the connection is being closed.
Now it is necessery to open the connection manually again(e.g command

Hello Friends
       I got a error [adErrDataConversion 3421] from VB6 when I read MSSQL database from ADO
       How can I fix this error
       Please relply to my email , thanks very much

On Windows 95,
* which version of MDAC is the best choice?
* without having installed DCOM, is it possible to install MDAC?
* what happens if I install MDAC 2.(x+1) after MDAC 2.(x) ?

I am working with VB6 in regard to this project.
I have two data grids. (DataGrid1 & DataGrid2)
DataGrid1 is populated with a large number of rows of data. (450,000+ rows)
DataGrid2 is populated with a large number of rows of data. (200,000+ rows)

Problem :
Select group of records using
sql=Select * from orders where customer = id etc
set rs = openrecordset(sql)

I've learned how to open connection to access via vb.
Is there a way to know on that access database how many tables, quries are
in the database and what are their names by ADO?
any help would be useful

I use: vb6, adodb.connection , db = access2000, blank password
I used this connection string:
.Provider = "Microsoft.Jet.OLEDB.4.0;Data Source=" & gsDBLocation &
"crm1.mdb" & ";User ID=Admin;Password=;"