Frank, There is a limit on the number of columns MS Access and MapInfo supports. Access 2000 only supports 255 (I think) columns in a single table. MapInfo has a similar limitation.
MS Access can have problems when you have around 20,000+ records in a table. Also you might want to reconsider your database design, 200+ columns is a lot of data in one table. Cheers Ian Ian Tidy GIS Administrator Works Asset IT Napier City Council mailto:[EMAIL PROTECTED] http://www.napier.govt.nz -----Original Message----- From: Phillips, Frank [mailto:[EMAIL PROTECTED] Sent: Saturday, 19 July 2003 2:44 a.m. To: 'MapInfo-L' Subject: MI-L Limit on Fields in an MDB? This question has probably been asked a million times, but I'm going to ask it again: Is there a limit to the number of columns/fields in an Access file (MDB) that MapInfo can read? I just tried to open a table in an MDB where the table has 225 fields and got an error. Frank Phillips Manager of Marketing GIS Vulcan Materials Company (NYSE:VMC) Birmingham, AL, USA --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7689 ###################################################################### This e-mail message has been scanned and cleared by MailMarshal ###################################################################### ###################################################################### Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. ###################################################################### --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7701
