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
