A personal preference of mine is not to use Microsoft Access as a backend for a database.
Access has a tendency to behave poorly with many users or hits at the same time. Also alot of people forget to close all sessions to access and leave a .ldb file out there when a copy is made. The .ldb file indicates which records are locked and by whom on a shared database.
Microsoft Access also has size limitations. 1 GB for Access 97, 2 GB for Access 2002 and 2000.
Access Corruption occurs under varying circumstances found here.
Subscribe and Share!
Did you enjoy this article? Your feedback is very important! I'd like to invite you to keep up to date with the latest posts from Anticlue. We offer several venues. If you have some questions, help can be found here.- Become a Facebook Fan
- Subscribe to Anticlue
- Follow me on Twitter
- Add to Technorati Favorites
- Digg this post
0 Comments to “Access for BackEnd DBs”
Please share your thoughts and suggestions
-
Receive Our eNewsletter
The latest Project Management and Healthcare IT practices
-
About Me
Welcome to the Healthcare IT Project Management Blog of Elyse Nielsen. This is the place where I share the ideas I have learned, the things I’d like to remember, and my thoughts for a brighter future. Find out more.
Subscribe to Our Tips
This weblog is licensed under a Creative Commons License.