From rajaram_k@netzero.net Tue, 29 May 2001 09:58:04 -0700 From: Rajaram Date: Tue, 29 May 2001 09:58:04 -0700 Subject: RE: RE: MS access Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yes, Dan is right, I just pulled up this info from Acess Help ( U can find more info when u search for "Specification" in access help) ******************* Database specifications ******************* Attribute Maximum Database (.mdb) file size 1 gigabyte. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity. Number of objects in a database 32,768 Modules (including forms and reports with the HasModule property set to True) 1024 Number of characters in an object name 64 Number of characters in a password 14 Number of characters in a user name or group name 20 Number of concurrent users 255 ******************* -----Original Message----- From: dan williams [SMTP:danw78704@yahoo.com] Sent: Tuesday, May 29, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: MS access 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: rajaram_k@netzero.net 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).