Right now I have a problem. I am using an access for the backend database of a .net application I am developing. The problem is that as it is, it is quite slow, but still acceptable. The problem is that this application needs to run from the network, which does present a problem, because I believe Access would just be TOO slow. There are also concurrency issues and what not.
My objectives are:
1. Database must be somewhat responsive where being used over a network.
2. Must be Very easy to use by non technical people. [install on server[if needed], install on client - works. No configuration]
3. Must be usable in .net easily.
4. Database may run on an average machine.
I can currently see 3 solutions.
1. Install MSDE, have the clients auto-detect.
2. Use another database engine, i've seen Fox and it appears to run quite a bit faster than Access. But I dont know how to use it.
3. Optimise Access... somehow.
Though, there could be others. I am just interested to know what the best solution for this situation could be, not an actual implementation. Im not interested in a lengthy response. Im just interested to know what the issues there could be, and people's experience has been in doing something similar.
Who ever gives the most ideal solution will get the project and the money immediately, pending conceptual details being clarified. Hopefully that is cool with rent a coder. Please let me know otherwise.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows.
Integration with Microsoft.NET
Database potentially on a non-client