> > >> -----Original Message----- > > >> From: rehughes2 [mailto:[EMAIL PROTECTED] > > >> Sent: Tuesday, May 03, 2005 11:28 AM > > >> Subject: Microsoft Access database > > >> > > >> > > >> All, > > >> > > >> I have a question about MS Access. I have been > told in the past > > >> that Access is not an "enterprise" database. > > >> > > >> Also it shold be kept small with a limited > number of users. > > >> > > >> I understand that it should be kept to 5 or > less users and > > >> a size of less thatn 10000 records. > > >> > > >> Is this information which I have received > questionable. > > >> Or basically true or YES it is TRUE. > > >> > > >> We are well over 5 users and well over 10,000 > records. > > >> Are we in a portentaly hazardous situation? > > >> > > >> Regards > > >> Ray Hughes
Howdy Ray, Taking the few moments to google "Microsoft Access Limitations" reveals a slew of links on the subject (which I've had to do before to justify using db's other than Access): first link is from 2002: (explaining the idea that Access is NOT the best RDBMS for multi-user environments such as the one that you have): http://www.teamits.com/internet/support/index.php?/internet/support/nt/msaccess_limitations.html the second link has links itself: http://www.aspfaq.com/show.asp?id=2195 a very informative article in and of itself, it leads you to: http://support.microsoft.com/default.aspx/kb/154869 (ah, right from the belly of the beast!) and so on and so forth. if you want someone to give you a guarantee that your application won't crash, or some "definable line" where what you have is "guaranteed" to become unstable, you probably won't get it. however, if you read the articles and what everyone says about using MS-Access as *any* kind of multi-user db, then you'll probably come to the same conclusion as the rest of us: "why risk the data? do it right from the get-go and use the appropriate tools for the job." HTH. Best regards, Andrew Matthews __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
