Kevin-
If it's going to be shared simultaneously by 100 users with heavy searches, then Access is probably not the right choice. It is possible to make it work with up to 100 users and light database access using just the desktop portion of MS Access. Look in our Files / Articles_Excerpts section for two chapters from my Building book that might give you an idea of how to design your application if you decide to go with Access. I recommend you start with the latest version of Access - but probably not anything before 2007.
Look for the files:
BuildingAccessAppsCh01.pdf
and
BuildingAccessAppsCH03.pdf
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 6, 2015, at 3:38 AM, 'Kevin Zhao' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Dear All,
I am going to design an access application for our company. My question is which version of access is the best? If my backend is shared internally by 100 people, is it ok to stay in access format instead of exporting it to the sql server? You know there's always errors when exporting/importing…
Thanks in advance,
Best Regards,
Kevin
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar