Article View: comp.databases.ms-access
Article #383Re: MS-Access Maximum Database Size and Performance
From: Joe "We are Borg" Foster
Date: Thu, 30 Jul 1998 00:00
Date: Thu, 30 Jul 1998 00:00
24 lines
2033 bytes
2033 bytes
In article <35BFC453.3C37EE36@earthlink.net>, nutropetfood@earthlink.net (NinkSink) writes: > Hello all. A few questions about MS-Access '97 on a Pentium > Does anyone know a ball-park figure of the max size an MS-Access '97 database can become > before MS-Access applications have performance and/or data integrity faults. I would also I haven't noticed any particular limits, but I've been playing in the 512MB range in both Access 2.0 and '97 and have been fairly careful in applying patches and creating indexes to speed up my queries. If you can avoid table scans, you should be OK. The data integity problems I was having for a while disappeared completely once I replaced my SOHO 100TX ethernet card with one from Bay Networks, go figure! -- Joe Foster <mailto:jfoster@ricochet.net> Spam is irrelevant. Assimilate this: <ftp://ftp.microsoft.com/softlib/index.txt> Microsoft's master patch list <ftp://ftp.microsoft.com/softlib/mslfiles/> MS I got yer patch right here! <http://www.microsoft.com/msdn/> MS Knowledge Base & more <http://www.dejanews.com/home_ps.shtml> Usenet search and archival engine <http://www.altavista.digital.com> WWW *and* Usenet search engine WARNING: I cannot be held responsible for the above They're coming to because my cats have apparently learned to type. take me away, ha ha!
Technical Details
Message-ID:
<11029@bftsi0.UUCP>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35BFC453.3C37EE36@earthlink.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 111a5a,a794ac29ee401323 X-Google-Attributes: gid111a5a,public X-Google-Thread: f8db2,a794ac29ee401323 X-Google-Attributes: gidf8db2,public X-Google-Thread: ff0ac,a794ac29ee401323 X-Google-Attributes: gidff0ac,public From: joe@bftsi0.UUCP (Joe "We are Borg" Foster) Subject: Re: MS-Access Maximum Database Size and Performance Date: 1998/07/30 Message-ID: <11029@bftsi0.UUCP> X-Deja-AN: 376246024 References: <35BFC453.3C37EE36@earthlink.net> Organization: Barbara Foster Tax Service, Inc. Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,it.comp.database.access