🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #383

Re: MS-Access Maximum Database Size and Performance

#383
From: Joe "We are Borg" Foster
Date: Thu, 30 Jul 1998 00:00
24 lines
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-mail
References: <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