VB Forum / Database Access / January 2006

I'm still with my connection string issue to DB.
So, i'm ok to encrypt everything but how can i do to not re-create the ODBC
interface ?
I mean to no create a form where are all fields concerning my connection string

We've got a VB6 program  that uses Access 97 databases and DAO 3.51. On
one computer, running a set of update queries and updating through
recordsets causes database corruptions. This only happens for larger
databases. All our other machines can do these updates fine on copies

I would like to know how do you do to store the connection string of an ADO
component.
Basically to access to a DB (to insert, update, select,..) we usually use the DB
administrator password and account.

I would like to know how do you do to store the connection string of an ADO
component.
Basically to access to a DB (to insert, update, select,..) we usually use the DB
administrator password and account.

how can i set the defaultvalue of a datarow with type datatime as Now's time
?

Hello sir,
How, can i pass any command line arguments (Through Run Command)
pass when my VB6 application execute and that's values
are receive when form activate.

I Need Help! Pls Help me Out!!
I m Using VB 6.0 & Sql Server 2000.
I have designed table Yearwise ie Company Master of Year 2005-2006 is
CompanyMaster0506.

How can I display number field with dashes in Oracle 9i ?
I tried following:
Select to_char(10000,'999-99') from dual
but its giving invalid number format model error.

Can I do this in one SQL statement?  If so, please tell me how.  I
have wasted a ton of time on this but there has to be an easy way to
do it.  I should have done it with more than one statement and been
done with it but I can't stop thinkin about it.

I have developed a Userform in Excel 2000 for entering data of Quotes and
Work Orders.  At present, the Quote data goes to a seperate spreadsheet than
the Work Orders.  The Userform enters the multiple data, either for Quotes or
Work Orders, depending on which button is selected, ...

I would like to write an application which allows users :
- to select a DB type (MS SQL, Oracle, ...)
- to create DB and users accounts
however, i would like to know what is the best method to do that.

I have a report created with Access 2003, I was wondering if there is any
lines of code I can write in a VB6 program to run the report from the VB
program. Can someone help please?
Thanks.