Bill,
perhaps you would be better to use an ODBC link to the access databases in
your case, so that you can avoid issues with table packing etc. If you
also link to your Access data from a forms/ report only Access database,
you will separate your data from the applications completely, and perhaps
provide a bit more security to the data. The apps could then go to
something a bit more substantial like SQL (or perhaps postgress) in the
future with minimal changes.
There is an also issue with editing Access tables that have indices where
the tables are stored in one Access database. MI crashes when you edit
one and then select from another from MapBasic (new versions of MapInfo
will rebuilt the indices automatically when this occurs when using MI
directly, but it still does it when the events are driven from MapBasic).
Basically you have to close all your access-based tables from that
database after saving and re-open them.
r
you are perhaps On Wed, 25 May 2005 15:59:33 -0600 (MDT), Bill Thoen
<[EMAIL PROTECTED]> wrote:
I've got several large Access databases that I want to use in a MapInfo
application, but I was wondering if I need to take any special steps to
keep them coordinated. In this case there is no mappable data associated
with the Access tables, and they are opened and modified in Access and
also in MapInfo, but never at the same time.
Will MapInfo keep up with changes made in Access, and will changes made
in
MapInfo be reflected next time the tables are opened in Access?
- Bill Thoen
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16571
--
________________________________________________
Robert Crossley
Agtrix P/L
9 Short St
PO Box 63
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309
F: 02 6680 5214
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
skype: robertcrossley
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16575
