I have a small database I use to keep track of the people that work
for me (about 200). They work all over the region and are divided
into a few work groups. I need to know every day that they are
working where they are supposed to. Having each of these people call
me is not the way I would prefer to muster them. My ideal solution is
to make this database information available available on my command's
web page. They would be able to log onto the web page and click in a
box to tell me what they are working on (i.e. report 1, report 2,
project 1, etc...) Since this database has some personal info in it
(SSN's, etc..) a password would be needed. I am an intermediate user
with a little knowledge and the tricky part as I see it is getting the
info on the web page to update my database in real time. I use MS
Frontpage for my Web Page. Do you think this is even possible? I
don't want to waste my time if it's not. Maybe you in the group won't
mind giving me your opinion on this project. I'm not asking you HOW,
just IF you think it will work. Of course, any knowledge you would
like to share would be much, much appreciated. Thank you for your
time.
corey lawson - 31 Jan 2006 10:25 GMT
> I have a small database I use to keep track of the people that work
> for me (about 200). They work all over the region and are divided
[quoted text clipped - 14 lines]
> like to share would be much, much appreciated. Thank you for your
> time.
Yes, it's pretty trivial to set this up with ASP & ADO, which is what
you would want to use, running off of an IIS webserver.
Instead of using the Office Web Objects (licensing issues), I just wrote
my own HTML form-generating ASP pages to display & edit things. Get a
good ADO book, and you should be OK.
the one major problem with ADO is that it uses VBScript, not VBA...
Don't make SSN's visible on the website would be the only thing else I'd
do. Maybe use last 4 digits, whatever.
Good luck.