I've run several sites very successfully off of Access in the past. Of course, these are small, limited usage sites, but using Access, I was quickly able to knock out functionality that I'd have needed have access to a net connection to develop or an expensive or complex server install to even use. (I do much of my coding on US-European flights)
That said, I think there comes a point where, as Daniel points out, you have to look at what you're doing and realize it's time to step up. 10,000 records and more than 5 users hitting it regularly? You bet you should move up.
Just because Access isn't SQL Server or MySQL doesn't make it bad! :)
Jake
Daniel Elmore wrote:
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
software)...or MySQL or PostgreSQL
(if you don't want to spend $$ or support the pirating of
records. InQuoting "Alford, Gary L" <[EMAIL PROTECTED]>:
I have not had problems with Access having more than 10,000
runs a littlefact, I have used it up to almost 100,000 records. It just
six users.slow. However, I have had tremendous problems with more that
time. IEspecially when they are trying to use the database at the same
Server.would highly recommend upgrading the database to Oracle or SQL
_____
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
