Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: MS access

Re:RE: MS access

From: <dgoulet_at_vicr.com>
Date: Thu, 24 May 2001 11:33:50 -0700
Message-ID: <F001.0030DE63.20010524113243@fatcity.com>

LI,

    Great idea, wonder where that came from! Just DON'T push the table definitions from Access into Oracle via Access. else you'll have objects that are a nightmare to access forever.

Dick Goulet

____________________Reply Separator____________________
Author: "Li; Xiangli" <Xiangli.Li_at_aig.com>
Date:       5/24/2001 10:51 AM

Hi , DBAs
Thank you veyr much for all replies. I think I have to go for oracle.

rgds,
Li

> -----Original Message-----
> From: Haskins, Ed [SMTP:Ed.Haskins_at_verizonwireless.com]
> Sent: Thursday, May 24, 2001 2:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      RE: MS access
> 
> Li,
>  
> 1GB for Access would be huge...and cause very poor performance.  The only
> way to overcome the size limitation is to upgrade to a real
> database...preferably Oracle, but that SQL Server thing would work as well
> for a DB that size.
>  
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>  
> 
>       -----Original Message-----
>       From: Li, Xiangli [mailto:Xiangli.Li_at_aig.com]
>       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 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19">
<TITLE>RE: MS access</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Hi , DBAs</FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Thank you veyr much&nbsp; for all
replies. I think I have to go for oracle.</FONT>
</P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">rgds,</FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Li</FONT>
</P>
<UL>
<P><FONT SIZE=1 FACE="Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">From:&nbsp;&nbsp;</FONT></B> <FONT SIZE=1
FACE="Arial">Haskins, Ed [SMTP:Ed.Haskins_at_verizonwireless.com]</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT SIZE=1
FACE="Arial">Thursday, May 24, 2001 2:26 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT
SIZE=1 FACE="Arial">Multiple recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=1

FACE="Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=1 FACE="Arial">RE: MS access</FONT>
</P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Li,</FONT>
<BR><FONT FACE="Arial"> </FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">1GB for Access would be huge...and
cause very poor performance.  The only way to overcome the size limitation is to upgrade to a real database...preferably Oracle, but that SQL Server thing would work as well for a DB that size.</FONT></P>

<P><FONT FACE="Arial"> </FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Ed Haskins</FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Oracle DBA</FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Verizon Wireless</FONT>
<BR><FONT FACE="Arial"> </FONT>
</P>
<UL>
<P><FONT SIZE=2 FACE="Tahoma">-----Original Message-----<BR>
</FONT><B><FONT SIZE=2 FACE="Tahoma">From:</FONT></B><FONT SIZE=2 FACE="Tahoma">
Li, Xiangli [<U></U></FONT><U><FONT COLOR="#0000FF" SIZE=2 FACE="Tahoma"><A HREF="mailto:Xiangli.Li_at_aig.com">mailto:Xiangli.Li_at_aig.com</A></FONT></U><FONT SIZE=2 FACE="Tahoma">]<BR>
</FONT><B><FONT SIZE=2 FACE="Tahoma">Sent:</FONT></B><FONT SIZE=2 FACE="Tahoma">
Thursday, May 24, 2001 11:57 AM<BR>
</FONT><B><FONT SIZE=2 FACE="Tahoma">To:</FONT></B><FONT SIZE=2 FACE="Tahoma">
Multiple recipients of list ORACLE-L<BR>
</FONT><B><FONT SIZE=2 FACE="Tahoma">Subject:</FONT></B><FONT SIZE=2
FACE="Tahoma"> MS access<BR>
<BR>
</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">Hi, List</FONT><FONT FACE="Arial"><BR>
</FONT><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">thanks</FONT><FONT FACE="Arial"><BR>
</FONT><FONT SIZE=2 FACE="Arial">Li</FONT><FONT FACE="Arial"> </FONT>
</P>
</UL></UL>
</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).
Received on Thu May 24 2001 - 13:33:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US