VB Forum / Database Access / February 2006

i am uing VB6 and ADO2.8 to connect SQL2000 by UDL file, but the problem is
when i need connect DB with UserName and Password anyone can see this
information in UDL file, how i can hide or encrypt this info without use
connection string in my Code?

This code is not working and I don't understand why.  I need the return value
and the output value from the procedure that is being called.
               On Error GoTo OpenAcctError
               Set myDB = New ADODB.Connection

i made a vb6-program with an Access2000 Database in the backend. i use
ADO 2.8.
When the program starts, an open ADO-Connection Object exists since the
program is ended by the user. The program should be used by 20 Persons.

I've posted this in another newsgroup, but wasn't sure if it was the
right one.
I was wondering if you could help me.  Basically, I'm wanting to do a
sort of auto complete in an access text box, with the help of visual

I have captured a GUID in a varchar(38) variable.  I am trying to pass
it to an ADO command as an Input parameter and am getting a Error 13
Type Mismatch.  Do I need to convert it to another datatype?

I have an application developed in VB 6.0 and MS-Access with DAo
connectivity.
While running the application i'm getting the error as"Couln't find
installable ISAM error."

I need register my Database (MDB) to ODBC DSN Database by VB programm
Where I can found example!
Thanks!
Stas.

I'm writing a real simple asp page to populate a table with records from a
SQL Server database.
After opening the recordset, recordset.RecordCount is showing -1, however:
1. BOF is false,

I am attempting to read data from an excel spreadsheet. I've included the
following code to show what I am doing.
Basically my application takes a spreadsheet and prints a label for each row
where a column named Print has a "1" in it. The issue is that if there isn't

I am using ADO to read a comma delimited file (CSV). The data in the
file is exported from Peachtree and contains embedded commans and
dbl-quotes in some of the data. ADO appears to have trouble reading
this and returns NULL when I reference a field with the embedded

I need to called the linked table manager in VB6 SP2 when the links have
been broken
I am using an ADO connection to an Access 2K mdb
Thanks

Hi there, I am working in Visual Studios 2005, "VB" and need a tab control
for my site.  I don't see it in the toolbox, any help on this?
Thank you, Mark

I am using VB6, MS Access 2003 and DAO.
I am using the following import code
mSQL = "SELECT * INTO tblDB "
mSQL = mSQL & "FROM [Text;Database=" & DBPATH & "\DB.mdb;HDR=Yes].[" &

I'm running VB6 with an MS Access backend using DAO.  I need to export either
a table of the results of a query to a .xls file.
How do I do this?
I tried

Hola foreros !!!
Me estoy volviendo loco!!!!!
Resulta que tengo un proyecto en Visual Basic 6 y lo distibuyo con el
MDAC_TYP.EXE 2.0 una vez compilado y empaquetado.