Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

REQ: Help with Accessing a database through the internet!!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dad - 30 Jan 2006 04:18 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
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.