VB Forum / Database Access / October 2004

I want to use "Option Explicit" to fore app declearation.
I don't konw which data type is suitable as shown belong. I tried to use
"Dim cn As Adodc", but it doesn't work.
Please help.

Hi every one, i need help with 2 things, plz
I am working on a new project on vb.net, I am creating a user input
screen for a  sql sever database table. I want the user to enter the
required information throught textboxes and datacombos, when the user

I need introduce a query sql in visaul basic code, can someone helpme
tks
--
__________________________________________

I just tried to build a database connection from vb6.0 to SQL Server 8.0 to
perform a simple query. See the codes below:
Private Sub cmdSearch_Click()
  Set cn = New ADODB.Connection

Dear,
I have prepared an excel form for users in our company to get external data
from oracle database. I used ADO method. Standart way to get external data is
when you describe a service provider in a connection string of the connection

I have a strange problem....
I've created a form with a scrollbar....
but when I minimize the form i get
a run time error '380'

I am a VB.NET programmer and I am developing a VB application where it would
be useful to place a large amount of text into a SQL Server 2000 database
field.  In the mid 90s I worked with Paradox databases and we used to have a
BLOB field that we could use to drop in objects like a ...

I want to indirectly access a field called "ID" I know this syntax is
wrong but I do not know how to corrected it
Dim db1 As Database
Dim  rs1 As Recordset

I have a Access2000 VB script that runs an Access query and then
outputs the data as a .csv file to a path specified by the user.
I need to have it export as a tab-delimited since some of the data has
commas.

My client wants to migrate from Linux to Microsoft. So I was asked to
translate a website build in PHP (with MySQL) into ASP.
Now I need to choose a database system to run with ASP.
My first guess would be SQL-Server, but my client's database is not very

Hello, use VB6 I'd like to password protect the database using the security
password in Access.  But I'd prefer to user the workgroup access way.  Is
there a ConnectionString I can use to get this to work?
I try:

Not Sure it this is the right group, if its not please direct me in the right
direction.
I am building a 3 Tiered Application That will manages some of my personal
information.

When i run this code i get this error
run time error 2147217904(80040e10)
That's the code...
Dim rs As Recordset

1. Dim cn as new adodb.connection
2. Dim cn as adodb.connection
  set cn = new adodb.connection
App works fine when using 1, and not when using 2.

Can you adjust a field size on the fly of a tabledef using DAO??
The field CompanyName was created and is too small. I need it to be 40 chars
not 30. Can I use code to look at the size and if it's 30 then either 1.
delete field and recreate field with right size, or 2 Just change ...