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
