I have a complex database I created that is accessed by everyone in my department on a local fileserver. I have many forms with VB behind the forms to perfom various functions/etc. ..
I have now been tasked with publishing some of my data via a secured web server for the entire company (dynamic pages). This server already has the frontpage extensions built in. I am somewhat familiar with Frontpage and with asp pages. I played around setting up a page using asp an an obdc connection to a database that was on my pc, but never much more. The pages I want to publish will pretty much only consist of a couple of dropdown boxes to filter the report parameters and then a submit button which will query my database.
So my questions:
1) Should I use ASP pages or something else?
2) The database on my departmental server has user level security enabled. Am I stuck having to periodically copy a version of my .mdb from my departmental to the web server?? or is there a way I could have only 1 database (which is what I want anyway)?
Any thoughts or suggestions would be appreciated in order to help head off any future problems.