RE: MI Mi: Large Access tables
I agree I've come accross this problem many times with large tables (150,000+ records). A way around the problem wounld be to export the table from MS Access as a dBASE (*.DBF)format and then import into MapInfo. For some reason MapInfo handles DBF formats much better. Hope this helps. ANDREW MCMILLAN --- "Sprenz, Martin" [EMAIL PROTECTED] wrote: I'm having the same problem with a fraction less records but a lot of fields. I hope someone has a solution to this problem. -Original Message- From: Markus Lindner Sent: November 30, 1999 10:08 To: '[EMAIL PROTECTED]' Subject:MI Mi: Large Access tables Hello List, I have a problem in registering large access databases. I want to register access tables as a mapinfo table which have more than 40 rows, and always end up in the message (translated from german): Microsoft Acess error. Not enough memory. Unable to register table xyz.tab The task manager does not show any usage of memory during this command, i am working with a pII, 266 128MB Memory plus 128 paging, disk is not full (ca. 1gb free) Smaller tables up to 10 rows work. I tried Mapinfo 4.5 4.5.2 5.0 and 5.5 Is this a known problem? Any hints are welcome, best regards, Markus -- Markus Lindner CISS TDI GmbH Tel. +49 2642 97 80 0 Barbarossastrasse 36 Fax. +49 2642 97 80 10 53489 Sinzig, Germany mailto:[EMAIL PROTECTED] http://www.ciss.de/ -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] = ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤øø¤º°` Andrew McMillan ,,, (905)433-1456(W) GeoSolutions-Bell Canada /'^'\ (905)985-3518(H) Oshawa, ON, Canada ( o o )(905)259-3515(C) oOOO--(_)--OOOo--- ___ Do You Yahoo!? Get your free @yahoo.ca address at http://mail.yahoo.ca -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI Mi: Large Access tables
A confirmation of that. We have been working with DBF tables with 41+ records without any problems and with appreciable speed. But I have not used Access in this context. Jacques Paris e-mailalternate [EMAIL PROTECTED] [EMAIL PROTECTED] paris PC Consult (mainly MapInfo app.) www.total.net/~rparis/gisproducts.htm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ANDREW MCMILLAN Sent: December 1, 1999 8:42 AM To: Sprenz, Martin; 'Markus Lindner'; '[EMAIL PROTECTED]' Subject: RE: MI Mi: Large Access tables I agree I've come accross this problem many times with large tables (150,000+ records). A way around the problem wounld be to export the table from MS Access as a dBASE (*.DBF)format and then import into MapInfo. For some reason MapInfo handles DBF formats much better. Hope this helps. ANDREW MCMILLAN --- "Sprenz, Martin" [EMAIL PROTECTED] wrote: I'm having the same problem with a fraction less records but a lot of fields. I hope someone has a solution to this problem. -Original Message- From: Markus Lindner Sent: November 30, 1999 10:08 To: '[EMAIL PROTECTED]' Subject:MI Mi: Large Access tables Hello List, I have a problem in registering large access databases. I want to register access tables as a mapinfo table which have more than 40 rows, and always end up in the message (translated from german): Microsoft Acess error. Not enough memory. Unable to register table xyz.tab The task manager does not show any usage of memory during this command, i am working with a pII, 266 128MB Memory plus 128 paging, disk is not full (ca. 1gb free) Smaller tables up to 10 rows work. I tried Mapinfo 4.5 4.5.2 5.0 and 5.5 Is this a known problem? Any hints are welcome, best regards, Markus -- Markus Lindner CISS TDI GmbH Tel. +49 2642 97 80 0 Barbarossastrasse 36 Fax. +49 2642 97 80 10 53489 Sinzig, Germany mailto:[EMAIL PROTECTED] http://www.ciss.de/ -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] = ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤øø¤º°` Andrew McMillan ,,, (905)433-1456(W) GeoSolutions-Bell Canada /'^'\ (905)985-3518(H) Oshawa, ON, Canada ( o o )(905)259-3515(C) oOOO--(_)--OOOo--- ___ Do You Yahoo!? Get your free @yahoo.ca address at http://mail.yahoo.ca -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI Mi: Large Access tables
We are currently processing tables that run over 1.5 million records each and frequently have two or three open at a time. No ha problemo. I do all of our large database manipulation in .dbf in pure DOS. Much faster and easier running software designed for a 12Mhz atmosphere in 450Mhz. No pretty pictures, ding dongs, or tooties, but quick processing. John D. Haynes Geodata Consultants 1-800-838-6661 www.geodataconsult.com -Original Message- From: Sprenz, Martin +ADw-Martin.Sprenz+AEA-pcs.bls.com+AD4- To: 'Markus Lindner' +ADw-ml+AEA-ciss.de+AD4AOw- 'mapinfo-l+AEA-csn.net' +ADw-mapinfo-l+AEA-csn.net+AD4- Date: Tuesday, November 30, 1999 2:26 PM Subject: RE: MI Mi: Large Access tables +-ACY-gt+-ADs-I'm having the same problem with a fraction less records but a lot of+-ADw-BR+-AD4- +-ACY-gt+-ADs-fields.+-ACY-nbsp+-ADs- I hope someone has a solution to this problem.+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- -Original Message-+-ADw-BR+-AD4- +-ACY-gt+-ADs- From: Markus Lindner +-ADw-BR+-AD4- +-ACY-gt+-ADs- Sent: November 30, 1999 10:08+-ADw-BR+-AD4- +-ACY-gt+-ADs- To: 'mapinfo-l+-AEA-csn.net'+-ADw-BR+-AD4- +-ACY-gt+-ADs- Subject: MI Mi: Large Access tables+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- Hello List,+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- I have a problem in registering large access databases. I+-ADw-BR+-AD4- +-ACY-gt+-ADs-want to+-ADw-BR+-AD4- +-ACY-gt+-ADs- register access tables as a mapinfo table which have more+-ADw-BR+-AD4- +-ACY-gt+-ADs-than 40+-ADw-BR+-AD4- +-ACY-gt+-ADs- rows, and always end up in the message (translated from+-ADw-BR+-AD4- +-ACY-gt+-ADs-german): +-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- Microsoft Acess error. Not enough memory. Unable to register+-ADw-BR+-AD4- +-ACY-gt+-ADs-table+-ADw-BR+-AD4- +-ACY-gt+-ADs- xyz.tab+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- The task manager does not show any usage of memory during+-ADw-BR+-AD4- +-ACY-gt+-ADs-this command,+-ADw-BR+-AD4- +-ACY-gt+-ADs- i am working with a pII, 266 128MB Memory plus 128 paging,+-ADw-BR+-AD4- +-ACY-gt+-ADs-disk is not+-ADw-BR+-AD4- +-ACY-gt+-ADs- full (ca. 1gb free)+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- Smaller tables up to 10 rows work.+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- I tried Mapinfo 4.5 4.5.2 5.0 and 5.5 +-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- +-ADw-BR+-AD4- +-ACY-gt+-ADs- Is this a known problem? +-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- Any hints are welcome,+-ADw-BR+-AD4- +-ACY-gt+-ADs- best regards, +-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- Markus+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- -- +-ADw-BR+-AD4- +-ACY-gt+-ADs- Markus Lindner+-ACY-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp +-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADs AJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg- nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp +-ADs- CISS TDI GmbH+-ADw-BR+-AD4- +-ACY-gt+-ADs- Tel.+-ACY-nbsp+-ADs- 2642 97 80 0+-ACY-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJ g-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nb sp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADs- Barbarossastrasse 36+-ADw-BR+-AD4- +-ACY-gt+-ADs- Fax.+-ACY-nbsp+-ADs- 2642 97 80 10+-ACY-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsA Jg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-n bsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADs- 53489 Sinzig,+-ADw-BR+-AD4- +-ACY-gt+-ADs-Germany+-ADw-BR+-AD4- +-ACY-gt+-ADs- mailto:m.lindner+-AEA-ciss.de+-ACY-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-AD sAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg -nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADsAJg-nbsp+-ADs- http://www.ciss.de/+-ADw-BR+-AD4- +-ACY-gt+-ADs- +-ADw-BR+-AD4- +-ACY-gt+-ADs- --+-ADw-BR+-AD4- +-ACY-gt+-ADs- To unsubscribe from this list, send e-mail to+-ADw-BR+-AD4- +-ACY-gt+-ADs-majordomo+-AEA-csn.net and put+-ADw-BR+-AD4- +-ACY-gt+-ADs- +-ACY-quot+-ADs-unsubscribe MAPINFO-L+-ACY-quot+-ADs- in the message body, or contact+-ADw-BR+-AD4- +-ACY-gt+-ADs-bthoen+-AEA-csn.net+-ADw-BR+-AD4- +-ACY-gt+-ADsAPA-BR+-AD4- +-ACY-gt+-ADs- --+-ADw-BR+-AD4- +-ACY-gt+-ADs-To unsubscribe from this list, send e-mail to majordomo+-AEA-csn.net and put+-ADw-BR+-AD4- +-ACY-gt+-ADsAJg-quot+-ADs-unsubscribe MAPINFO-L+-ACY-quot+-ADs- in the message body, or contact bthoen+-AEA-csn.net+-ADw-BR+-AD4- +-ACY-gt+-ADs- -- To unsubscribe from this list, send e
RE: MI Mi: Large Access tables
I'm having the same problem with a fraction less records but a lot of fields. I hope someone has a solution to this problem. -Original Message- From: Markus Lindner Sent: November 30, 1999 10:08 To: '[EMAIL PROTECTED]' Subject:MI Mi: Large Access tables Hello List, I have a problem in registering large access databases. I want to register access tables as a mapinfo table which have more than 40 rows, and always end up in the message (translated from german): Microsoft Acess error. Not enough memory. Unable to register table xyz.tab The task manager does not show any usage of memory during this command, i am working with a pII, 266 128MB Memory plus 128 paging, disk is not full (ca. 1gb free) Smaller tables up to 10 rows work. I tried Mapinfo 4.5 4.5.2 5.0 and 5.5 Is this a known problem? Any hints are welcome, best regards, Markus -- Markus Lindner CISS TDI GmbH Tel. +49 2642 97 80 0 Barbarossastrasse 36 Fax. +49 2642 97 80 10 53489 Sinzig, Germany mailto:[EMAIL PROTECTED]http://www.ciss.de/ -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]