Using MS Access/ms access

Advertisement


Question
QUESTION: Hi, am developing a database for 300 users. is it possible to use ms access? thanks.

ANSWER: Are you talking about 300 concurrent users? What will the app be doing?

Scott<>

---------- FOLLOW-UP ----------

QUESTION: Yes, 300 concurrent users, it's a database where the company put their 1 year plans and update on monthly basis. Thanks.

ANSWER: Ok, it sounds like most of the users will be just viewing and reporting on data. I question that you would have 300 users all logged in at the same time.

I think Access can handle this, but it is pushing the envelope a bit. An Access front end with a SQL Server back end would be better. Also depends on your network topography.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

---------- FOLLOW-UP ----------

QUESTION: Hi Scott,

Thanks a lot for your reply. Sorry, actually this will be my first application development so I have quite a lot to ask in mind. Would like to enquire how to do SQL server as back end?

Thanks.

Answer
One of the advantages of Access is that it can integrate data from many sources. The easiest way to use a SQL Server database as a back end is to use ODBC. You create a data set name for your SQL Server, then connect to it using the external data ribbon in Access.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.