VB Forum / Database Access / July 2007

I have a record set that I am displaying with getstring().  I need to
format one column only using FormatDateTime.  How do I do this?
Thank you.

I'm writing an application where the user creates a custom DataTable. How
can I convert it to an ADO Recordset, so to be able to save it to an Access
Database ? Or, is there any other way to directly save the DataTable as a new
Table in Access Database ?

I have debug statements in my Stored Procedures, which I want to display to a
"text" control placed on a VB6.0 form.Events flow from one SP to
another and I want all the statements.
In short, I want to trace the path ,of the flow of events, at the server

I have two tables with the following components:
1. authTable - shop order no, auth no, work center id
2. dbo_shopOrder - shop order no, work center id
I would like to do a few things but I am not sure where to start.

how to read records from Text file and insert into SQL record using VB? i use
following src code and able to
add in the first record in Text file, but how can i move to the next record
in text file so that i

Can a Storedprocedure be created using code in VB6?
If so how?
Is there some sample code?
TIA

I'm getting the error:
"The Microsoft Jet database engine cannot open file \\Xpws03\C:\Test.mdb.
It is already opened exclusively by another user, or you need permission to
view its data."

Dear All,
how to write the to Ms Excel File by retireve data from SQL Server.
below src code i use:
Public Sub Write2Excel()

Dear Group,
I would like to read the input and output parameters of a stored
procedure within the Connection.ExecuteComplete event handler.
Unfortunately, I have found that if I do this while using

Testing this file

In Access 2000, whenever any of the controls
on any of the forms in my database tries to
launch VBA (in the form, of, say, an "event
procedures" attached to a triggered event

I am facing a really weird problem and can't figure it out.
I have my application that uses ADO to connect to SQL 2000 database.
I have 3 parts to my application. The main app, then a .dll that does
all database work like connections and queries that is called from the

Hello;
I'm on XP Pro, using VB6 and an SQL Server Database on our server.  I can't
seem to connect - keep getting "Error 3709 - The connection cannot be used
to perform this operation. It is either closed or invalid in this context".

Can someone tell me why this isn't working?  I'm trying to use a bookmark to
go to a particular record in a recordset.  The recordset is from an Access
97 database.  Here's the code:
Dim sConn As String

I have an Index field.. set to autoincr and as primaryindex
Others using the database are saving the index value of certain records to be able to retrieve them
later (no other fields are guaranteed unique). I am wondering if this could be a problem.
1. Can these index values ever be ...