Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: MS access
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 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: </FONT></B> <FONT SIZE=1
FACE="Arial">Haskins, Ed [SMTP:Ed.Haskins_at_verizonwireless.com]</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">Sent: </FONT></B> <FONT SIZE=1
FACE="Arial">Thursday, May 24, 2001 2:26 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">To: </FONT></B> <FONT
SIZE=1 FACE="Arial">Multiple recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=1
FACE="Arial">Subject: </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