A confirmation of that. We have been working with DBF tables with 410000+
records without any problems and with appreciable speed. But I have not used
Access in this context.
Jacques Paris
e-mail alternate
[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 400000
> 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 100000 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]
