Mike This may not be very encouraging to you. I think that your problem is a feature of Access's queries - not MapInfo's connection to them.
Although it is possible to set properties for each field of an Access query (eg, the Format and the Input Mask, and the Caption), even if you change your query to an (Access) Make Table query and use Properties to format each field (eg, your calculated field which has only 3 text characters), the newly-created Access table will have 255 characters for any calculated text field. [ I'm testing this, with Access 2003 ] However, a work-around is to create a new Access table - within Access - to delete any old data in a purpose-built table, and then append new data obtained by querying 'original' tables to this table. The newly-created can be structured with the field lengths that you want. Of course, that's not dynamic - when the data in the underlying Access tables changes, you would need to run some routines within Access to re-generate the nicely-formatted table, which you then may link to with MapInfo 8. You can do this with a couple of queries or a macro. IL Thomas GeoSciSoft - Perth, Australia -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cummings, Mike Sent: Saturday, April 15, 2006 2:39 AM To: MapInfo-L@lists.directionsmag.com Subject: [MI-L] Problem linking MI8 to MS access query file. This is really an annoying access query/export problem. I have a access query with a "calculated" field. the results of this field is three characters of text. When the query is linked and viewed in the MI browser the "calculated" field is 254 characters. You can get the same results by exporting the query as a "DBF" file & importing the "DBF" to access then looking at the file structure. Has anyone have a fix? Is there a MS access function I haven't found or know how to work around this & still have a refreshable MI table? Thanks All. _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
