web applications

[Guest]

I have been developing a database for about the past two years that manages
student attendance records for our board's adult education department. My
boss thinks it's ready for all four of our campuses to use the same system. I
know I could put a copy of the database on each location's server and have
them used independantly. This would be simple now but difficult to manage in
the future...ie making changes four times over?

I think what would be best would be to compile the database into a web
application and have a query run when a user logs on to identify which campus
they are from and launch the appropriate form so as to have data entered into
the right tables, etc...

Could anyone point me in the right direction to begin learning how to go
about doing this in a way that would be user friendly for teachers entering
data and secure for the sake of protecting sensative personal information for
our students?

Thanks in advance for any input or suggestions.

 

[Rick Brandt]

I have been developing a database for about the past two years that
manages student attendance records for our board's adult education
department. My boss thinks it's ready for all four of our campuses to
use the same system. I know I could put a copy of the database on
each location's server and have them used independantly. This would
be simple now but difficult to manage in the future...ie making
changes four times over?

I think what would be best would be to compile the database into a web
application and have a query run when a user logs on to identify
which campus they are from and launch the appropriate form so as to
have data entered into the right tables, etc...

Could anyone point me in the right direction to begin learning how to
go about doing this in a way that would be user friendly for teachers
entering data and secure for the sake of protecting sensative
personal information for our students?

Thanks in advance for any input or suggestions.

Well, there is no way to take your Access app and "...compile the database into
a web application...". To "webify" an Access database application means keeping
your MDB file for the data only and re-writing everything else in a web
technology like ASP or ASP.Net.

This is not simple nor quick to do. Unless you are interested in the (long)
learning experience you would be better off hiring a web developer.

 

[Guest]

Rick,
Thank you for your response...albeit not what I wanted to hear, what I think
I knew was the case.

As our budget does not allow for the hiring of a web developer and I have
never been one to shy away from a learning challenge, could you please
perhaps suggest what my first step "down the long road" might be? Any
reference materials I could look up to get me started? I really would rather
take a learning curve here and now and avoid having to manage and maintain 4
individual databases, 2 of them remotely.

Thanks again.