I posted this before but got no replies from the list. I’m trying again, hoping that someone from spss will comment, before I push it up to tech support.
Here’s the output.
GET DATA
/TYPE=ODBC
/CONNECT='DSN=MS Access Database;DBQ=R:\FWT\Articles\ParFAM3\Fam3Refs.accdb;DriverId=25;FIL=MS '+
'Access;MaxBufferSize=2048;PageTimeout=5;'
/SQL='SELECT Rec, Type, Ident, Author, PYear, Title, Source, FAM3Used, Alphas, ItemTotal, '+
'Factor, Topic, Notes FROM Refs'
/ASSUMEDSTRWIDTH=255.
CACHE.
EXECUTE.
Warning. Command name: EXECUTE
SQLFetch (getting tables) failed :[Microsoft][ODBC Microsoft Access Driver]String data, right truncated on column number 6 (Title)
DATASET NAME $DataSet WINDOW=FRONT.
Truncation occurs at character 151. The fieds are defined in Access as short string A255.
My version is 22.0.1, which, as far as I can tell is the latest (and last) patch. All this makes me think there’s a (never to be fixed) problem here.
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
