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:[EMAIL PROTECTED]]
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.
--- [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
> Date: 5/24/2001 9:02 AM
>
> MS accessIf it's true use an Oracle Database...hehehhhehhh...Just
> kidding...sorry:(
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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
>
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD><TITLE>MS access</TITLE>
> <META http-equiv=Content-Type content="text/html;
> charset=iso-8859-1">
> <META content="MSHTML 5.50.4207.2601" name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=218025615-24052001><FONT face=Arial color=#0000ff
> size=2>If
> it's true use an Oracle Database...hehehhhehhh...Just
> kidding...sorry:(</FONT></SPAN></DIV>
> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT
> face=Tahoma
> size=2>-----Original Message-----<BR><B>From:</B>
> [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]<B>On Behalf Of </B>Li,
> Xiangli<BR><B>Sent:</B>
> Thursday, May 24, 2001 11:57 AM<BR><B>To:</B> Multiple recipients
> of list
> ORACLE-L<BR><B>Subject:</B> MS access<BR><BR></FONT></DIV>
> <P><FONT face=Arial size=2>Hi, List</FONT> <BR><FONT face=Arial
> 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?</FONT></P>
> <P><FONT face=Arial size=2>thanks</FONT> <BR><FONT face=Arial
> size=2>Li</FONT>
>
> </P></BLOCKQUOTE></BODY></HTML>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
