To Axel Heeren -
The most obvious way to hotlink from Mi to ms-access is to open the
Ms-Access database directly in mapinfo. One of the downsides of this method
is that you exclude other users from using the Access database while your
using it from MapInfo. Besides that, you can only use the access based
_data_, not forms, indexes ... You can probably use a ODBC connection to
yor Access-data, too.
If you want to hotlink your MapInfo-data to Access-data _inside_ MS-Access
you can use (at least one...) another method, which involves a lot of
programming:
1) Develop a function/procedure with parameters in a dll that - via OLE -
can control Access to focus on the relevant Access-record. This step
requires knowledge about programming dll's (not so tough), threads (somewhat
tougher) and com interfaces (abysmal) - but it can be done. The function
uses the parameters to decide which access record to focus on.
2) Develop a mbx that contains a "SelectionChanged" Handler that - when
triggered - will call the dll - based function. The syncronization between
MI and Access is done by having a column in both the Mi - and the Access -
table which contains the same values. When triggered, the SelectionChanged
handler transfer the value from the relevant MapInfo column to the dll. The
dll controls which access record to focus on via the parameter.
With some modification, the method can be used to control an access-forms
based application too.
I have already programmed the above mentioned system. I can't give you the
code (my employer would _not_ like that), but if you are interested, you
can mail me for a quote.
Good Luck..
Bo Thomsen
GeoConsult I/S
[EMAIL PROTECTED]
> -----Oprindelig meddelelse-----
> Fra: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sendt: 12. august 1999 10:45
> Til: '[EMAIL PROTECTED]'
> Emne: MI MapInfo Object hotlinks to MS ACCESS data sets
>
> Greetings to all:
>
> Has anyone had any experience with hotlinks to MS ACCESS database. (object
> related hotlinks to an equivalent data set in MS Access)?
>
> Thanks a lot in anticipation.
> Axel
>
> -----------------------------------------------------------------------
> Axel Heeren
> Kathe-Kollwitz-Ufer 43
> 01307 DRESDEN
> Germany
> E-Mail: [EMAIL PROTECTED]
> -----------------------------------------------------------------------
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
