VB Forum / Database Access / January 2007

I can tell if a field is a primary key or unique because there are
methods for those.  I can't seem to figure out if a field is being
indexed otherwise.  This is the case in the Access GUI where the
'Indexed' attribute is set to "Yes (Duplicates OK)".  If duplicates

We have a large app that runs Client - web tier - SQL. All data transmission
uses disconnected ADO recordsets. A customer is looking to migrate the back
end to an Oracle db running on a windows box. They have some form of apache
web service that exposes data from Oracle as text, ...

I've a strange problem:
In the statement :
With cmIL
       .ActiveConnection = conDM

This is how I am trying to display the records existing in a MS-Access
(by executing a Query that is Access as well):
Dim objConn
Set objConn = Server.CreateObject("ADODB.CONNECTION")

I am very new to VB progamming.
Please help me with the problem below.
I have a database created in microsoft access
i have a combobox in my vb application interface

Hi, me again
Can someone plz tell me why this query takes over 1 sec. The table has some
4000 records, and 72 columns.
Or is it concidered 'normal'?

Given a CSV file in C:\DATA\ALL.csv that starts as follows:
"Object Short Text","Object Level","Created By","Last Modified By","Object
Text","Object Number","Created On","Last Modified On","Object
Identifier","UCorUCS","Object Heading","Absolute Number","Created Thru"

I have a table in access (tbl_ReportList) that has four fields (ID,
Emailto, CC, and RptName). The email and CC fields both have e-mail
addresses in them and the RptName field is a list of reports in the
database. For now I only have three: Report1,Report2,Report3.

I believe my question is the simple one. I have searched the google
group and the internet for the info but none is directly relevent to my
question.
I just want to create a simple VB program with 4 buttons in which each

I'm looking to rewrite a substancial existing MS Access/VBA app in VB
6, as a multiple document interface.  I'm very solid in VBA in Access,
and refreshing myself in VB after a long time having only done simple
programs.

I'm developing a SW in VB6 that writes to an Access 2003 table while
another SW (set up as a Windows Service) is reading the same table and
erasing the records as they're read. I noticed a lapse of about 1 sec.
between writing and reading and I think this is due to a delay caused

I have run into this interesting problem recently that if I try to find a
record with query that looks like :
Select * from CUSTOM WHERE QTREF = '217898.001'
it takes much longer than if I use :

If one is using a server side cursor from a provider that only
implements an adMoveForwardOnly cursor, what exactly are the movement
limitations, and what are the expected results if you violate them?
IE, I know you can't do recordset.MovePrevious, but can you do

If we create a global connection variable called g_oConn, open this
connection, then do the following, have we created two distinct connections
to the datasource?
We're doing this as one possible means of dealing with problems encountered

How to rotate any text 90 degree anticlockwise or -90 degree? I like to
draw specific chart and want to rotate text in Y Axis title.
TIA
Yanto