VB Forum / Database Access / February 2006

i think executing the stored proc in VB and VBA are very similar. so, i
posted the question to here to see if someone has came across the same
problem before...
i'm trying to execute a stored proc stored in Sybase in VBA EXCEL 2003. the

I have been trying various methods to destroy windows, but can't seem to
make them work.  I can set focus api correctly, and bring the application to
the foregrounds, but destroywindow doesn't kill the window.
Does anyone have an example for this that really works?

Hello dear Newsgroup!
We are developing an application in MS-VisualBasic SP 6. Our database
is SQL Server 2000.
After a coversion from a Win2000 platform to WinXP we are getting the

I want to connect to a odbc database and delete one record in a table
I wrote this code in vb6
  Set wrkJet = CreateWorkspace("", "", "", dbUseODBC)
  Set db = wrkJet.OpenDatabase("dboresh2", , False, _

I have a situation where I would like to return a value from a stored
procedure in SQL server, how do I receive the value using ADO?
strSQL = "sp_rename_company '" & strNewCompanyName & "'"
cn.execute strSQL

Hi...
We have a VB 6.0 application which has 128 forms, 6 modules, and 54
class modules in it. We are currently looking at moving from Access DB
as our back-end to SQL. Converting a database from Access to SQL is not

I am trying to loop through a DAO recordset and replace characters as
needed.  However, when the replacement consists of just appending a
character, the first record in the recordset seems to move to the end
of the recordset after the first iteration through the loop and has the

I have an application using VB6(SP6) and Access 2000. They all have MDAC 2.8
installed and all the SP and updates for their operating system. Even if two
users are not doing the same things some how the table(s) got locked up and
they have to close out our program and do compact ...

Salve, ho un problema.
Ho da importare diversi contenuti, in tabelle di Access2000, di file .txt
utilizzando Transfertext.
Il tutto mi funziona ma solo se Access è aperto utilizzando le "Specifiche".

When defining a table in Sql server I there is a field for a description of
the column.
Is there any chance to access that property from within .net?
I have seen a similar property named "caption" in the dataset designer, by

I have a VB program which retrieves double data from a AS400 database
using ADO connection.
cnn.Open "Provider=IBMDA400;Data Source=myAS400Machine;", "", ""
Suppose the name of my result  recordset  is myRst, even when  I use msgbox

I use DAO in a VB6 project. I have a table with a few colums there, one
of them is dbMemo.
I have a RTF box for notes in the program, and for some reason, when I
assign text longer than 1900~ (aprox) characters to the field with

I am using VB6 application (very old) with an Access 97 database.
The database is quite large (close to Access limit of 1G) and is used
over the network from multiple location.

-------- Original-Nachricht --------
Betreff: GUID an Access2000
Datum: Mon, 20 Feb 2006 10:27:24 +0100
Von: Peter Plumber <Klempner@gmxdot.net>

I keep getting this error when trying to submit a form I created on
Dreamweaver that is connected to an Access database:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no