ACCESS FEED: Re: [MS_AccessPros] Re: Backend

Kamis, 10 Desember 2015

Re: [MS_AccessPros] Re: Backend

Go read the two chapters in Files / Articles_Excerpts

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

http://www.viescas.com/

(Paris, France)

On Dec 10, 2015, at 2:40 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John

I will have 1G for the backend.

Best Regards,

Kevin

发自我的小米手机

在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月10日下午9:04写道：

Kevin-

It's not so much the amount of data as the amount of simultaneous activity. How many users will be in the application at the same time?

You can actually support up to 100 simultaneous users if your application is designed carefully to limit the amount of data being moved over the network to each user. Go look in the Files / Articles_Excerpts section on the website for the two chapters I posted from the Building book.

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
http://www.viescas.com/
(Paris, France)

On Dec 10, 2015, at 1:02 PM, svkroy@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Also depends upon the quantum of data you want to store..

---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@...> wrote :

Dear All,
Is that ok to use ms access as the backend for less than 50 people? Since there's attachment type field in the tables, it's not compatible with sql server.
Best Regards,
Kevin