VB Forum / Database Access / June 2006

We've been getting this error intermittently from our VB 6 COM objects
accessing an Access 2000 database. The client had ADO 2.5 installed so
we upgraded to 2.8. We still get the error.
It only seems to happen during large processes (reports -many objects

Hope someone can help - i am trying to learn some VB and i am trying to use
recordset.find to locate a record in a .mdb table i created but i get
errors.
Has anyone got a simple snip of code to show me so i can see how you locate

In WinXP SP2, if I change my regional option to 'Maori', and run my ADO
'SELECT'queries, they fail.
It return the following error-
'-2147217865 (80040e37)':

I'm a newbie trying to work on Visual Basic. I have an excel template with
five fields (Field1, Field2, Field3, Field4 and Field5). My requirement is;
(1) The program to prompt for two inputs (Field1 & Field2)
(2) The program then searches the excel, and the lists all the entries ...

L.S.
I'am writing an application in Visual Basic 6.0 in which I have multiple workstations working with the same access database on a central computer (server).
Is it better to frequently open and close a database or just once open it on starting the application and once closing ...

I have a VB6(SP6) application with Access 2000 database. It has been working
fine till recently. If 2 users are doing totally different data entry
procedure, on one computer it will get that message and the user has to close
out the application and come back in. It happens a ...

I have Visual Studio 6, 2003 and 2005 on my Xp Sp2 PC. We have SQL Server
2000 running under Windows Server 2003.
VS 6 and VS 2003 connect to the sql server with no problems, but VS 2005
always times out! This is true of code or using the database connection

How do I store binary data into a VarBinary(Max) field instead of an Image
field?
I have a table name 'FileTable' on my local SQL SERVER 2005.
The table has only one field.

I have to send attachment to more than one recipients in VB using MAPI.
Recepients address are seperated i.e.
MAPIMessages1.RecipAddress = textname.text
Here textname.text =abc@zc.com;pqr@fg.com

This morning a program that has been functioning smoothly for months
started timing out whenever it attempts a connection to the database.
The DBA says nothing looks wrong on his end.  When I run it uncompiled
from the design environment it works fine, as does the same connection

I query the Customers table from Northwind database and I want to fill my
combobox with CompanyNames. When the user chooses one item from combobox, I
must get its CustomerID to query Orders table and display the orders of this
customer in the grid. What's the easiest way to get the ...

I made a database program in vb6 on an windows XP system, using Jet.
Database, datagrid control, etc. Then made a setup program with the
package/deployment wizard. The setup program works fine on other XP
machines and the program also runs fine. But, on windows 98 systems,

I'm new to vb.net and databases.  I have a class to execute a stored
procedure that displays the data in the command window.  The parameter value
is hard-coded into the class code, but I would like to have a form pop-up
that asks for the parameter.  How would I do this?

Anyone knows the syntax of  querying the file system using the indexing
services ?

Hi friends,
I have 3 byte arrays and how can I append the 2nd and 3rd array into the 1st
array without using Loop and with using loop. Note all 3 are Byte Arrays.
Thanks in Advance