Article View: comp.databases.ms-access
Article #384Re: MS-Access Maximum Database Size and Performance
From: Scott LaPointe
Date: Thu, 30 Jul 1998 00:00
Date: Thu, 30 Jul 1998 00:00
46 lines
2577 bytes
2577 bytes
My database is 250MB and I keep getting Unrecognized Database Errors all the time. It's a pain in the ass. -- ------------------------------------ Scott LaPointe Internet Outlook Inc. Tel: (506) 854-0211 Fax: (506) 854-0270 Web: http://www.ioi.nb.ca Email: ioi@mon.auracom.com Personal Web: http://www.ioi.nb.ca/scott Email: scottl@mon.auracom.com Joe "We are Borg" Foster <joe@bftsi0.UUCP> wrote in message 11029@bftsi0.UUCP... >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:
<6pq1ik$sdf$1@news.auaracom.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35BFC453.3C37EE36@earthlink.net> <11029@bftsi0.UUCP>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: ff0ac,a794ac29ee401323 X-Google-Attributes: gidff0ac,public X-Google-Thread: f8db2,a794ac29ee401323 X-Google-Attributes: gidf8db2,public From: "Scott LaPointe" <scottl@mon.auracom.com> Subject: Re: MS-Access Maximum Database Size and Performance Date: 1998/07/30 Message-ID: <6pq1ik$sdf$1@news.auaracom.net> X-Deja-AN: 376352179 References: <35BFC453.3C37EE36@earthlink.net> <11029@bftsi0.UUCP> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0518.4 Organization: Auracom Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,it.comp.database.access