time sheets form

[rathika]

hi

i have desinged a timesheet form which will be used by
around 30 to 40 employees to enter the time sheets.
now this form should be available in each one of the
employees machine and as they enter the data it has to go
to the database.

i have 2 doubts.

1. my doubt is should i spiltt the database and provide
the form to the users ? or copy the database with forms
to each one of their pcs.

2.also if i splitt then should I store this form in a
network folder or should i go to each one of their
machines and copy it in their machines.

pls. give me a good and efficent solution.

i am confused.

 

[Hugh O'Neill]

hi

i have desinged a timesheet form which will be used by
around 30 to 40 employees to enter the time sheets.
now this form should be available in each one of the
employees machine and as they enter the data it has to go
to the database.

i have 2 doubts.

1. my doubt is should i spiltt the database and provide
the form to the users ? or copy the database with forms
to each one of their pcs.

2.also if i splitt then should I store this form in a
network folder or should i go to each one of their
machines and copy it in their machines.

pls. give me a good and efficent solution.

i am confused.

Assuming that all of your users have Access on their machines, you
should definitely split any multi-user database into front and back
ends. The back end will be just the tables and will reside in a shared
folder on the network. The front end will need to be copied to each
user's machine and run from there. Splitting the database is done by
using Tools > Add-ins > Database splitter.

Of course I don't know how simple or complex this time-sheet
application is but for simple time-sheets, I would have thought that a
database approach might be a bit heavy-handed.

hth

Hugh