VB Forum / Database Access / November 2006

When using DAO (the program was inherited), the first execute on the
database object is causing another connection to be created within the
database.  I this normal or can it be fixed?  The weird thing is that
the workspace only shows one database object within the databases

All Certifications Like
MICROSOFT,CISCO,COMPTIA,SOLARIS,ORACLE,SAP,MICOSOFT BUSINESS
SOLUTIONS,EMC at your doorstep without exams..and with 100% passing
guarantee...No need to go to any testing centre...we will do everything

We have this code in access:
Private Sub Get_Skills(strtemp2 As String, stForm As String, stLoad As
String)
On Error GoTo Err_get_skills

hello everybody. i want to search fields in my table. but i got an
error.if some can help.
here the error:
"Microsoft OLE DB Provider for SQL Server (0x80040E14)

hello every body! i want to count records in my field "patient_result"
where it has the value "positive".but its not working.its just
displaying the value "1" meanwhile i have 10 "positive"
records in my field.if someone can help!

Lately I am having very strange issue with my code and not sure what is
causig issue.
I have following code which creates new entry in table
===========================================

When using DAO (the program was inherited), the first execute on the
database object is causing another connection to be created within the
database.  I this normal or can it be fixed?  The weird thing is that
the workspace only shows one database object within the databases

I have an SSOLEDB gird which uses an ADO data control. The grid allows
updates, the problem I have is that if the user changes a record then moves
on to another record everything works fine. However if they leave the record
in edit mode and close the form then the record does not ...

To make a long story short, does anyone know how we can get a copy of this
hotfix (see Article 884038)?
We have been trying to setup an ODBC connection to a database to download
shipping records into UPS Worldship.  

VB 6 Pro front end to Access 2000 useing DAO
I get this error 3265 item not found in collection when I am trying to see
if a table exists in my database.
Can anyone tell me how to trap this error. Here is my code. It works with a

VB 6 pro front end to access 2000
I found some code to back up my access database during runtime, it works
fine. Now I need some code to open a database during runtime.
I would like the user to be able to open an archived database from a

I am making the pages asp of one library on-linens with visual study 2003. I
have created the datagrid, the subroutine UpdateCommand. .now I want to
avoid to always insert the same element. .someone says me like making? I
would have to make a IF. .but like? In order to help to ...

Dears all,
can anybody help with this stuff.
I can'nt rid of with MyODBC 5.0 and connection string in Visual Basic 6
using ADO. I must connect to mysql server 5.1 trought myodbc 5, but i do'nt

I am trying to switch a VB6 application from SQLOLEDB to SQLNCLI (SQL Native
Client) in order to use the new features of SLQ Server 2005. An
ADODB.Connection seems to work so far, but as soon as I try to retrieve any
data my Recordsets stay emtpy although the queries arrive ...

I'm currently using the vb data controls to write numbers to excel
spreadsheets using the Jet driver.
Unfortunately, even though the data being sent to the spreadsheet is
numbers, excel has a nasty habit of showing them as text, requiring them