[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