From danw78704@yahoo.com Tue, 29 May 2001 08:46:04 -0700 From: dan williams Date: Tue, 29 May 2001 08:46:04 -0700 Subject: Re:RE: MS access Message-ID: MIME-Version: 1.0 Content-Type: text/plain I've been working in Oracle for 4 years and Access for 6 years, and can assure you that for Access 97 (size limit is 1 g), Access 2000 (size limit is 2 g), Access 2002 (size limit is 4g). I've had 500 mg database that work fine in a multiuser environment, however if there is a need for a enterprise solution, then using a enterprise tool is better suited. --- dgoulet@vicr.com wrote: > Kevin!!! > > Li, > In reality Access does have a file size limit, but I believe it > is much > lower than 1GB. Regrettably there is no way around it, except as > Kevin stated > to use a pass through query to Oracle. One should understand that > Access is > designed as a single user system that gets bastardized into multi > user > applications with a lot of resulting trouble. > > Dick Goulet > > ____________________Reply Separator____________________ > Author: "Kevin Kostyszyn" > Date: 5/24/2001 9:02 AM > > MS accessIf it's true use an Oracle Database...hehehhhehhh...Just > kidding...sorry:( > -----Original Message----- > From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Li, > Xiangli > Sent: Thursday, May 24, 2001 11:57 AM > To: Multiple recipients of list ORACLE-L > Subject: MS access > > > Hi, List > Is there anyone happen to know what's the database size > limitation for MS > access97? I heard it's 1 gigabytes, how to overcome it if that's > true? > > thanks > Li > > > > MS access > > > >
size=2>If > it's true use an Oracle Database...hehehhhehhh...Just > kidding...sorry:(
>
>
face=Tahoma > size=2>-----Original Message-----
From: > root@fatcity.com > [mailto:root@fatcity.com]On Behalf Of Li, > Xiangli
Sent: > Thursday, May 24, 2001 11:57 AM
To: Multiple recipients > of list > ORACLE-L
Subject: MS access

>

Hi, List
size=2>Is > there anyone happen to know what's the database size limitation > for MS > access97? I heard it's 1 gigabytes, how to overcome it if that's > true?

>

thanks
size=2>Li > >

> > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: dgoulet@vicr.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dan williams INET: danw78704@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).