Are you using MapInfo version 6.0? Mapinfo's integration with Access is
very flakey in Version 6.0. Expect many general protection faults when
trying to access the data through MapBasic, particularly if your tables are
indexed and more than one table is stored in the one access database. I am
not sure if opening up a query through ODBC affects or creates indexes, or
if you have other indexed tables in that database.
The issue could also be related to not having the correct DSN set up on the
other machines, and the general protection fault is a consequence.
My advice is to try sticking to Mapinfo version 5.5 if you are using Access
97 base tables, or hope that version 6.5 fixes the problems if you are not.
But while on the subject, read on if you are remotely interested in the
indexing issue. I spent 6 weeks of my life trying unsuccessfully to get to
the bottom of this issue, so forgive the rant if it has nothing to do with
your problem.
I have had some success avoiding the GPF problems by deleting mapinfo
indexes from Access tables whenever my program does edits, and recreating
those indexes after the tables have been saved. This workaround was given to
me by the technical staff at mapinfo. It is only a workaround though.
The only way you can control when changes are made to the data is by
controlling how the table is opened, and checking if you can lock the table
before trying to edit it. I open tables read-only except when editing is
done, and this allows many people to view it, but others cannot change the
data when someone is editing the data. When you want to edit it, you have
to re-open the table in deny write mode to stop others from changing
anything (it fails if someone else is editing), and then delete all indexes
before saving the changes, then recreate the indexes, then open it up in
read-only mode again. This is a real pain if the indexes are neccessary in
making the edits (as they are with me).
The problem is still that if anyone else has those tables open as read only,
MapInfo wants them to rebuild the indexes when changes was made, can't as
they are open read-only, then gives a general protection fault.
Even more fun can be had if users want to access the data through Access at
the same time (which is why you are probably developing in that environement
anyway), as this forces a request to rebuild indexes and gives the GPF.
Robert.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Keith
Miller
Sent: Wednesday, 18 April 2001 2:44 AM
To: [EMAIL PROTECTED]
Subject: MI-L DBMS/ODBC and Access parameter query (CALL)
Greetings MapInfo-ers.
I am trying to open a Access parameter query in MapInfo through DBMS/ODBC,
with MapBasic (I know, I never take the easy way!). I found out how to do it
on one machine, with the Server Link Table command, using "{CALL
qryName('para')}" as the SQLQuery. This works fine on my development
machine, but doesn't work on any other machine--it dumps me out of MapInfo
completely and logs a Dr. Watson error. I can't figure out why it works on
my machine but not any others. Help???
----------------------------------------------------------------------------
--------
Keith Miller
Principal Planner: GIS and Modeling
North Jersey Transportation Planning Authority, Inc.
One Newark Center, 17th floor
Newark, NJ 07102
973-639-8444
[EMAIL PROTECTED]
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~
Digital GEO data for 125 countries
LAND INFO International produces digital geographic data for over 125
countries. DEMs, satellite imagery, topo maps, vector map layers,
flood maps, and more. Visit http://www.landinfo.com/indexdm1.htm and let
our specialists find the right solution.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
