Hi Dina, The only way Access can store geography is by converting two X and Y columns into a point object theme. This requires (of course) two numeric columns with coordinates _and_ an entry in a special table named MAPINFO_MAPCATALOG.
Have you by any chance deleted either coordinate column or the mapcatalog table ? Or perhaps deleted the appropriate entry for your table in the mapcatalog table ? Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ http://hjem.get2net.dk/lars-online/ WGS84: 10.20'40"E 55.20'20"N ----- Original Message ----- From: "Korkovelos, Dina E, CSLSM" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 12:04 AM Subject: MI-L Linked table error When attempting to make updates to a linked table I receive this error msg "The keyword object cannot be translated b/c the table is not mappable. Unable to refresh linked table." Any guesses to why? The process I'm running on the table will updated the DISTANCE_TO_NET field, the process takes >2hours. Could I be timing out? How do I change that? Here's the metadata too. !table !version 400 !charset WindowsLatin1 Definition Table Type LINKED Charset "WindowsLatin1" Fields 30 ID Integer ReadOnly ; BLDG_CLLI Char (8) ; GEOADDRESS Char (254) ReadOnly ; GEOCITY Char (50) ; GEOSTATE Char (2) ; GEOZIP Char (5) ; GEOZIP4 Char (4) ; GEORESULT Char (254) ReadOnly ; PLANNING_AREA_ID Char (3) ; DISTANCE_TO_NET Integer ; ADDRESS Char (254) ReadOnly ; CITY Char (50) ; STATE Char (2) ; ZIP Char (5) ; ZIP_4 Char (4) ; FIBER_STATUS Char (254) ReadOnly ; BBW_STATUS Char (254) ReadOnly ; BBW_MSA_ACTIVE_LIST Logical ; TOTAL_EDS1 Integer ; LD_EDS1 Float ; LD_DS1 Float ; LD_DS3 Float ; LD_OC3 Float ; LD_OC12 Float ; LD_OC48 Float ; LOCAL_EDS1 Char (254) ReadOnly ; LOCAL_DS1 Char (254) ReadOnly ; LOCAL_DS3 Char (254) ReadOnly ; OSP_COSTS Char (254) ReadOnly ; BUILDING_CPA_ID Char (254) ReadOnly ; begin_metadata "\DATALINK" = "" "\DATALINK\ConnectionString" = "DBQ=E:\Digital Atlas\Digital Atlas.mdb;DefaultDir=E:\Digital Atlas;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=E:\Digital Atlas\File Data Source\Digital Atlas.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeou" "\DATALINK\ConnectionString\+1" = "t=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes" "\DATALINK\Query" = "select `ID`, `BLDG_CLLI`, `GEOADDRESS`, `GEOCITY`, `GEOSTATE`, `GEOZIP`, `GEOZIP4`, `GEORESULT`, `PLANNING_AREA_ID`, `DISTANCE_TO_NET`, `ADDRESS`, `CITY`, `STATE`, `ZIP`, `ZIP+4`, `FIBER_STATUS`, `BBW_STATUS`, `BBW_MSA_ACTIVE_LIST`, `TOT" "\DATALINK\Query\+1" = "AL_EDS1`, `LD_EDS1`, `LD_DS1`, `LD_DS3`, `LD_OC3`, `LD_OC12`, `LD_OC48`, `LOCAL_EDS1`, `LOCAL_DS1`, `LOCAL_DS3`, `OSP_COSTS`, `BUILDING_CPA_ID`, `OBJECT` from `E:\Digital Atlas\Digital Atlas`.`ACCESS_REDUCTION_OPPORTUNITIES`" "\IsReadOnly" = "FALSE" end_metadata Dina Korkovelos GIS Analyst - Local and Access Nat'l Bus Dev AT&T Local Network Services [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5564 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5575
