VB Forum / Database Access / November 2004

Is it possible to add yor own properties to a database (mdb) field or table?
Just wondered, I can also easily just add tables to keep the info I want.

I M TRYING TO CONNECT ACCESS AND ORACLE WITH VB FORMS WITH THE HELP OF ADODB .
THE TABLE HAS MORE THAN 1 LAKH RECORDS IF I TRY TO CONNECT VB FORM WITH THAT
TABLE THAT PARTICLUAR FORM TAKES MORE THAN 5 MINUTES TO GET DISPLAYED ON THE
SCREEN WHAT SHOULD I DO TO OVERCOME THIS PROBS.

i use a recordset to take values form a storeprocedure,
 Set rec = New ADODB.Recordset
 rec.ActiveConnection = Connectio
 rec.Source = "cev_take_from_sismap"

Is there a way to achieve this in VB 6 ?
Thanks in adv.
Meng

My .NET application needs to know if the currently logged on user has rights
enough to create global tables, indexes, stored procedures, views, etc in
the current database.
The program runs through routines that create all these tables and we have

I'm trying to access the SQL Server 2000 database from VB6, but getting this
error:
3709  Requested operation requires an OLE DB Session object, which is not
supported by the

Lets look at the following code:
   cm.CommandType = adCmdText
   cm.ActiveConnection = conn1
   Set rs1 = New ADODB.Recordset

Form a visual basic program I am passing a SQL statement to retreive data
from SQL server database. If I need to cancel this request while it is
processing (for ex. if my sql takes long time), can we do it from the
form/control using a command button. If so how can we do it.

I get this error when I try to bring an application written in VB 4 into VS
6??
Could not find Data Access Library.  Cannot Create reference.
Visual Basic tried to create a reference to the Microsoft DAO Object Library

I got the [Adodc]: Unknown Error [Ado]; on a vb6 application connected to
Access 97 or 2002. It occured on some computers with Win XP (about 50% of the
ones I installed it on). There is no clear similarity on which it works and
which it doesnt seeing as most of them originated ...

Hope this is the right place to post.
I'm using VB6/ADO/Access. I want to get the date a table was created. I've
had a hunt around Google and found several suggestions. However, the most
common 2 don't seem to work for me. I've tried

I need to import data from multi Spreadsheets with VB6 code. My code doesn't
work properly, can anyone help?
Private Sub ImportSchedules(ByVal strFilename As String)
   Dim mXlsApplication As Excel.Application

I have been working with VB6 using ADO to access a SQL Server database
and to save me work I have written a dll to simplify database access.
I have found it so useful that I am considering releasing it as
shareware.

One table of an Access database contains a date/time field.
How can I SQL query for records within that table that have an empty
date/time value ?

I'm hoping that somebody can steer me in the right direction to solve a
problem that I'm having at the moment.
I have Access database called EP3SAM.
The Database has one table (tblAuthorisedUsers) with fields: