VB Forum / Database Access / September 2005

I have been assigned to a small project which implements a program that
imports data from other applications to our DB (Access).
Some data are *.dbf so no problem.
But some are custom binary files that I need to parse.

I am new to programming in VB6 and I have written a program for the
local
school in India to enable them to maintain their records of students
and

I have found on Google various pieces of code that check wether a table
exists or not but they all seem to also make VB return an error after a TRUE
or FALSE statement.
I was wondering if anyone has a "clean" function/method that would check and

VB.NET newbie here, this is probably an easy one.
I am using a bound DataGrid as a multi-column selection list -a list of
customers is displayed where one can be selected and updated in another
windows form. After the update, the user is returned to the initial window

Is there a function that I may not know about that will allow me to
tell programmatically if the user is part/member of a domain or not?
I am not an expert about this domain stuff but it is how our network
guy explained it to me. The big picture is this – our

I have a job where it will involve checking large volumes of addresses
against a master address table.
The master address table contains approx 1.7 million addresses.
The files (normally CSV) I must check against will contain anything

I have been trying to connect to a databse (Access) using ADO and learn it
at the same time.
When I Dim a connection in my "regular" project Intellisense shows me an
ADODB option and things work fine for now.

I have the following questions about VB 6.0 interfacing with sql server 2000:
1. I have heard that VB 6.0 can run with inline SQL. Can you show me how to
use
inline sql to access a sql server 2000 database?

Ive developed a VB6 app that uses a access 2000 database over a LAN
(Network) etc.
I now want to be able to access the database with my VB app via a URL
Is this possable and if so can someone point me in the right dirction

Most of my ProductOptions can be priced directly to the Products they relate
to. But then I have a small group that also has minimum or maximum widths to
determine the pricing. It appears that the easiest solution is to simply
include the minimum and maximum width columns in the ...

I'm having trouble getting my stored proc to add decimals to the field. Do I
need to specify the precision and scale in the parameter and if so, how
would I do that. I did try the sql books but can't seem to find it.
Thanks,

   i have to make some modifications to an old visual basic programs and i
have some problem with the user of the
   The programs open a record setting a client cursor, open a recordset and
set the recordset property to nothing to detach the recrdset from the

Created a vb.net windows service which connect to a database by using OleDb.
Using a connectionstring pointing to a local sqlserver database everything
works fine, but when connecting to a database on another server the
connection.open method executes without errors but the ...

Transitioning an app from VB6/JET to VB6/SQL2k. The previous JET code
returns 3 records but the new code returns 0 from the same table. The new
code:
Public Db As New ADODB.Connection

I have created a connection object to my sqlserver using the following
connection string:
"Provider=SQLOLEDB;Password=*******;Persist Security Info=True;User
ID=**;Data Source=" & sServerName & ;Initial Catalog=" & sDatabase