Timesheet application

[DevAccess]

Hi

I am developing timesheet application which would be used by approx 80 users, I will have temp table I will get require data and then will submit to main table, having 80 users of the application would have any issues here?, offcourse I will split the database as front end and backend where in front end would have link table from main db.

Do I have to take any precautions while 80 users are using the dB?

 

[pbaldy]

Is there a question?

 

[DevAccess]

Is there a question?

I modified the original question. Thanks

 

[BeeJayEff]

A timesheet application can be extremely simple or it can get rather complicated. Do you have many tables in your design ? Why have you decided that you need a temporary table ? 80 users is quite a lot for an Access application - would you expect large numbers of them to be using the app at the same time (e.g. start or end of day/week/month) ?

 

[pbaldy]

80 is a lot of concurrent users, but it might be okay if they are only adding records, or only clocking in and out at the beginning/end of the day, etc. You can also consider using SQL Server as the back end. There is a free version available. More thoughts here:

http://blog.fmsinc.com/microsoft-access-database-scalability-how-many-users-can-it-support/