odd access problem

[Maguin, Eugene]

Does anyone have any insight into this? I had initially thought that the command had failed but the table actually was read. I also had thought the problem was that a record had a title string longer than the field width (255) (and therefore was right truncated) but the longest string in Title is 150. Or, am I completely misunderstanding what the message means?

Thanks, Gene Maguin

 

This syntax is ran from the syntax menu.

 

*  ACCESS DATABASE FILE.

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, Notes FROM Refs'/

   ASSUMEDSTRWIDTH=300.

CACHE.

EXECUTE.

 

Warning.  Command name: EXECUTE

SQLFetch (getting tables) failed :[Microsoft][ODBC Microsoft Access Driver]String data, right truncated on column number 6 (Title)

 

 

 

 

===================== 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

[Andy W]

I've had this before. The database I was using was a linked table in Access to another database and the fields were free text - so could be well over 3,000 characters. I'm not sure how the string fields were initialized in either Access or the linked table - but I personally never had any data integrity issues with the strings for what its worth. (They were just truncated - like the error message stated)