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_at_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" <kevin_at_dulcian.com>
> Date: 5/24/2001 9:02 AM
>
> MS accessIf it's true use an Oracle Database...hehehhhehhh...Just
> kidding...sorry:(
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_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
>
>
> <!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>
> root_at_fatcity.com
> [mailto:root_at_fatcity.com]<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: dgoulet_at_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_at_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_at_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_at_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).
Received on Tue May 29 2001 - 10:46:04 CDT
