VB Forum / Database Access / June 2004

With regard to the Access 97 MDB file format versus the Access 2000 (or even the latest Access 2002/2003) MDB file format:
Is a particular Access MDB file format considered the "most friendly" to VB6 DAO code-based Access DB processing, or does it NOT matter at all which file ...

Should I expect any problems attempting to do BOTH of the following in the SAME VB6 project application/executable:
1.) Use the DAO object model in a VB6 app to programmatically access via code the tables of a locally co-located Access .MDB database, AND;
2.) Use the Data ...

Thank you in advance for any and all assistance. Is there a better way to open
and close forms with a module or control?
I'm currently using the frm.show and frm. hide events, but I'm afraid I'm going
to eat up memory, since I'm not unloading the form from memory.

Thank you in advance for any and all assistance. How do you close an
application in VB 6.0 vs. just unloading a form ?
Michael

I am working on enhancing the performance of a very large
transactional sql svr database application.  The app has used temp
tables frequently against a SQL Server 2000 database.  The database is
experiencing slowdowns and lengthy blocks, particularly when it is

I have a VB application that send a SELECT statement to an ODBC driver using
ADO.
In the ODBC driver trace I see that my application is handing the driver 2
different formats of the SELECT statement and yet, my VB application program

I tried to debug a stroed proc remotely. Happened following error
information;
Server: Msg 514, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to communicate

I have an append query which writes certain records from a table in one
dabase into a table in another database as follows:
cn.Execute "INSERT INTO synchplay ( FileName, CamNo, Path ) IN 'C:\edds.mdb'
SELECT " & CurCam & ".Filename, " & z & " AS Expr1, '" & TodaysAppPath & "\"

There are two ways to execute a stored procedure using ADO
- call "exec sp_myproc val1,val2" statement over ADO
- use Command/Parameters objects to initialize and call the stored procedure.
Which is a efficient way and why

Datetime type column value return "date + time"(2004-06-10 00:00:00.000)
when i using select statement. In UI how can i just display the date
portion (2004-06-10)?
Cheers,

I have the following ADO code and SP to update a couple of tables. The update works fine except for the ApptStart column which is smallDateTime. I would be grateful for any help. I've been working on this for hours.
Private Sub cmdEnter_Click()
On Error GoTo Error_Handler
   Dim ...

I populate ADODB.Recordset from SQL Server stored procedure. It contains
thousands of records with SellPrice and Invoice Date fields. Now I need to
have another Recordset which will contain Sums of SellPrices for each year.
Is it possible to create that recordset without writing a ...

I'm still learning how to use ADO mostly from reading other people's code.
I'm using VB6 (SP5) on WinXP.
I see in another application that the programmer sets up a connection and
closes it each module of the project. What are the advantages or

Would you guys help me with some of my questions please?
Let's say I open a recordset with 10 records in it.
While I am opening the recordset, I place a lock on it so that others cannot
modify the 10 records in my recordset.

I was doing some experimentation with the GetRows method.
I have read in a couple of differnet places that GetRows is faster than
using a recordset.  Well, it seems that I am not getting results that
reflect these claims.