VB Forum / Database Access / April 2005

Is there a way in VB6 to setup a continuous form like in MS-Access?
I've got my app connected to an Access DB with ADO, and can cycle
through the records one by one, but I would like to show the records in
a continuous form like in Access... is this possible?

I'm getting an error randomly and intermittently throughout my COM+ object.
It doesn't seem to tied to any particular database call, although it seems
to occur more frequently while opening the database.
The error from the Errors collection is this:

In a simple table link manager function, I'm trying to use
"Set Db = OpenDatabase("C:\Mydatabase.mdb")
On Err = 0 Then
   TLinks = True

I have a VB6 application running under XP that has suddenly started to
fail to run, producing the error messages:
A)   Data error event hit :[ADODC]: Unknown error. [ADO]:
B)   [ADODC]: Unknown error. [ADO]:

VB6 SP5  DAO
ACCESS 2003 SP1
I would like to execute an SQL-Update
in which an own Function is called

I have inherited a VB project. It opens in VB 6, but it has 2 Designers,
that sya "Class Not Registered" when i try to open them.
1st what exactly are designers and how do I solve this problem.
Thanks

I opened a database but on the same file as a database I got wierd file with
the same name as my database the the type of file is called a Microsoft
Access Record-Locking...  .  I thought I closed my database the right way
with code the only way I can even access the database is ...

I have never understood it. I understand the Why very well. I want to create
a vb dll (little test to exercise learning on connection pooling) which
opens and closes connections with wreckless abandon. I want opens to use
connections in the pool. I want to be able to see, touch ...

Dear Experts,
This works during design time without problem but after i execute compiled
code it shows 3021 no records or current record is deleted :
the code is as follows:

I have a different error now here it is:
Can anyone help?
  UpdateTable = "INSERT INTO [EmployeeInfo] ('First','Last Name') " & _
  "VALUES ('Leon', 'Johnson')"

I have an Sql statement that want work here is my code:
Can anyone help me and tell me what I'm doing wrong and
tell me what websites can I find out more information?
  Dim UpdateTable As String

Using client side cursors with OLEDB.  When issuing the update or
updatebatch methods I get:
"Insufficient base table information for updating or refreshing."
I have looked into this and found that each field in my RS must have 3

I am try to save the recordset in excel file.  But i am not able to do this,
it is displaying in unknownformat.
rs.save "d:\test.xls"
this is my code.  How can i export the data from recordset to excel?

A weird one (for me at least)
I have VB6, SP5 enterprise edition installed. I note from dllhell that this
installs DAO350.dll (3.51.1608) and if I unregister it VB will not start.
I also have dao360.dll installed  (3.60.8618).

Dear Experts,
I would like to know if i can find a record from a table on two parameters.
namely FirstName and LastName?
All the examples in help has only one parameter!