By empirical in this context I mean no one is capable of verifing or disproving an answer/conclusion because no one has an exact copy of the environment (his database, it's user load and the servers).
Ray, you want to read Adrian's link, it's the best link given. http://www.aspemporium.com/tutorials.aspx?tid=12 - Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, May 03, 2005 2:03 PM To: [email protected] Subject: RE: Microsoft Access database for more info on Access, try this: http://en.wikipedia.org/wiki/Microsoft_Access Other interesting links: http://en.wikipedia.org/wiki/Database_management_system http://en.wikipedia.org/wiki/ISAM and finally.. With regards to an 'empirical' answer (relying on or derived from observation or experiment). My OBSERVATION has been that SQL Server, DB2, Oracle, MySQL, PervasiveSQL and PostgreSQL (all of the RDBM's I've had significant exposure to) blow the socks off MSAccess in PERFORMANCE. But, you'd be hard-pressed to find one of the above that you could develop an application faster in (with all of the features Access offers). More often than not, I use Access to connect to disparate systems for migration/conversion issues, quick reporting (if I'm not building a web-based system), or a simple stand alone app. oh..and for about $40, you can buy this software (http://www.convert-in.com/acc2sql.htm) to convert your access database into mysql. I've used it and it works great... Good luck! Quoting Daniel Elmore <[EMAIL PROTECTED]>: > No one will be able to give an empirical answer to your question. Gather all > the facts and then make a choice and you alone are the best one to make the > decision. The link Adrian gave is superb, read it over. > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of rehughes2 > Sent: Tuesday, May 03, 2005 11:54 AM > To: [email protected] > Subject: RE: Microsoft Access database > > > I do not subscribe to "pirated" or pirating software. > > I do believe in use of "free" and the reuse of public > access software. > > Hopefully some other will provide some facts on MS Access. > Are we in a portentaly hazardous situation that wiht more > than 5 users the DB could crash? > > Thanks & Regards > Ray Hughes > > > ---------- Original Message ---------------------------------- > From: [EMAIL PROTECTED] > Reply-To: [email protected] > Date: Tue, 3 May 2005 11:43:58 -0500 > > >...or MySQL or PostgreSQL > > > >(if you don't want to spend $$ or support the pirating of > software) > > > >Quoting "Alford, Gary L" <[EMAIL PROTECTED]>: > > > >> I have not had problems with Access having more than 10,000 > records. In > >> fact, I have used it up to almost 100,000 records. It just > runs a little > >> slow. However, I have had tremendous problems with more that > six users. > >> Especially when they are trying to use the database at the same > time. I > >> would highly recommend upgrading the database to Oracle or SQL > Server. > >> > >> > >> > >> _____ > >> > >> Gary L. Alford > >> Manufacturing Operations Project Specialist > >> Bell Helicopter XWorx > >> Phone: (817) 280-6233 Fax: (817) 278-6233 > >> [EMAIL PROTECTED] > >> <mailto:[EMAIL PROTECTED]> > >> > >> I have not failed. I've found 10,000 ways that won't work. > >> Thomas A. Edison > >> _____ > >> > >> > >> > >> -----Original Message----- > >> From: rehughes2 [mailto:[EMAIL PROTECTED] > >> Sent: Tuesday, May 03, 2005 11:28 AM > >> To: [email protected] > >> 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 > >> > >> ________________________________________________________________ > >> Sent via the EV1 webmail system at mail.ev1.net > >> > >> > >> > >> > >> ---------------------------------------------------------- > >> 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 > >> > >> ---------------------------------------------------------- > >> 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 > >> > >> > >> > > > > > > > >---------------------------------------------------------- > >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 > > > > > > > > > ________________________________________________________________ > Sent via the EV1 webmail system at mail.ev1.net > > > > > ---------------------------------------------------------- > 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 > > > > > > ---------------------------------------------------------- > 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 > > > ---------------------------------------------------------- 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 ---------------------------------------------------------- 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
