[AccessD] Data interface The best way

Jim Lawrence accessd at shaw.ca
Thu Oct 20 13:48:26 CDT 2005


Hi Gustav:

Thanks for that information. Some 'real' work has now got in my way too and
I will have to get but to the fun later. This info will give me a start
point.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, October 20, 2005 5:10 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Data interface The best way

Hi Jim

You have two options: ODBC or OCX.

ODBC works quite nicely and doesn't require further explanation.
The OCX is the CacheObject where you need something like this:

  Dim fac As CacheObject.Factory
  Dim obj As CacheObject.ObjInstance
  Dim res As CacheObject.ResultSet

I did play around with the OCX but was interrupted by real work. You
somewhat loose the feeling of Access; it's more like VB where you move data
back and forth but I guess you get used to it - or would write some wrapper
class. Or just fall back to ODBC and use Access the normal way.

/gustav

>>> accessd at shaw.ca 19-10-2005 19:26 >>>
I have been playing with Caché recently and found the database creation a
very interesting and refreshing. Totally OOPS (Still getting my head around
that one.) 

I have just been following the tutorials but tried some data importing the
other night and it seems to run very fast... 370,000 records and the data
searches are basically instantaneous. 

Nothing unusual for a major DB but the interesting thing is that I did not
have to specify a database or table or field. Now the next big hurdle is how
this can be attached to Access. (A friend likened it to towing a battle-ship
with a VW.) 

Jim


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list