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 > > > > MS access > > > > size=2>If > it's true use an Oracle Database...hehehhhehhh...Just > kidding...sorry:( > >face=Tahoma > size=2>-Original Message-From: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Li, > XiangliSent: > Thursday, May 24, 2001 11:57 AMTo: Multiple recipients > of list > ORACLE-LSubject: 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: [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).
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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > 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:[EMAIL PROTECTED]] > 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 > RE: MS access 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]] 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 -- 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).
Re:RE: MS access
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 MS access If it's true use an Oracle Database...hehehhhehhh...Just kidding...sorry:( -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Li, XiangliSent: Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list ORACLE-LSubject: 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 -- 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).
