VB Forum / Database Access / March 2008

Good Day!
I created a Query which used a User-Defined Function I also created. It runs
smoothly while Im inside the MS Access. The BIG problem occurs when Im trying
to call the Query from inside my VB Application - it was like saying that the

how write an code which can create an desktop short cut icon of my choice on
installation of my application automatically

I've installed MySQL (version 5.0.51a) and am trying to learn to use
it in a program written in Visual Basic 6. The VB6 program has been
using both ADO and DAO to manipulate data in an MS Access MDB file.
Using the examples shown here:

Is there some trick to creating a temp table on a SQL server through the ADO
connection object? This code works fine if I create a permanent table, but
doesn't do anything if I add the # to create a temp table
Option Explicit

I've converted code from my Visual Basic 2005 application that used microsoft
access 97 in order to use SQL Server 2005, but i'm having problems on saving
records. V.Basic gives me no errors but the record is not updated.
Dim strSQLInsert As String = "INSERT INTO Paciente ...

Hi, i have had very little experince with using databases and visual basic,
currently i have juust produced a basic log in screen, however now.
I need three combo boxes.
The first should indicate the contents of the second, and the second should

Hi, I have a SqlServer on my ISP and a ASP application wich feeds the db, so
what is the best way of copying the data from internet to the local db
customer?
Should I open a remote OLEDB SqlServer connection pointing to internet IP

Hi im currently having a problem with taking data from a field in a database
and then using it within the form, when supplied with a telephone number by
inputting in
to a text box, the number needs to be checked against the database and then

hi i have got a visual basic 6 application that uses an access 97 database
stored on the c: drive of my machine. what i want to do is have 2 or more
copys of then program accessing the same database over the internet by ftp
or telnet some way. does any one have any ideas on ...

I am writing an application using VS2008 and SQL Server 2005. I have
code that executes a stored procedure for a table that has a field
which is varchar(max). I usually use code as follows to create and
populate a parameter...

I'm the first time here , I say you a  good day
Can somebody please to learn me if ADO
can do an autofill method in a closed workbook ? ...
... to do in a closed workbook the same action

I have a problem that I can't seem to resolve.  I have three encrypted
fields in an SQL Server database that I access using a VB 6 program.  In
code, I can write SQL to decrypt the fields like "SELECT
DecryptByKey(fldEncryptedField) as DecryptedField" and that's fine.

I use ADO to update data in SQL2005 db from vb application.
It updates about 400 records with Execute method from Connection object
and then give an error message "SQL Server doew not exist or access
denied". How this can be fixed? Should I increase ConnectionTimeOut or

Hopefully someone can help me.  I'm still new to VB development and have been
given a project to support that was developed a few years ago.  We recently
moved the application to a new server and now one the reports that is
produced has more records on it that it should.

I am using Visual Studio 2005.
What I need to do is to be able to read a table into Visual Studio, the
table is stored inside a Access Database. How can I do this?
D