earlier it was a mess, not it's complete on the access side but there needs to be a web browser interface. (IE ONLY) I'm wanting to know what tools are needed to run MS Access on my server and have people in BFE execute, edit, and save the changes. come on, i know this has been done!!!
someone, anyone, throw me an idea!
thanks
chris<pixelmonkey>
nothing is yet coming to mind, or to thread...
i need ideas, have any to share?
chris<pixelmonkey>Originally posted by pixelmonkey
<SNIP.....>(IE ONLY) I'm wanting to know what tools are needed to run MS Access on my server and have people in BFE execute, edit, and save the changes. come on, i know this has been done!!!
<SNIP....>
I do it all the time. ASP is good for this. Three things need to be done -
Allow the db to read (get a recordset)
Allow the data to be edited (via webform)
Write changes to the db (update a recordset)
Now you can do more like, delete or create a record in Access also via the web. And since its ASP it doesnt matter if its IE or NS.
Take a look at <!-- m --><a class="postlink" href="http://www.asp101.com">http://www.asp101.com</a><!-- m --> and study their tutorials. I learned a lot there the first time around
hthwill the current user interface be dynamically updated depending on changes on the origonal Access file? keep in mind it's doing a relay post on the server... first the Access database, then the excell database. The database will be viewed by one person, never by the techs. I just closed a ticket number with microsoft for help on this and was told the Data Access Page would be limited to what can be done and would also be static. Does anyone disagree with this?
always looking for a loophole
chris<pixelmonkey>ok, what about ODBC? what do i need on the server and what format do i need the pages in?
slipping in and out of the lit world
chris<pixelmonkey>Ok lets see - 1st things 1st.
Yes the web server will require ODBC to be installed (I'll presume we're dealing with IIS here).
Secondly -
The web page only provides an interface to the data. It will allow you to create, edit and delete data within the db. It does not directly manipulate the data unless specifically instructed to do so.
thirdly -
Yes the interface will most likely be static UNLESS your displaying data from the db in which case it will be updated everytime the page is viewed.
forthly -
access and excel are not the same thing nor is excel a database, its a spreadsheet which has different ***ntionality altogether. You can easily manipulate the access db to display data like excel, (even with auto-updating!)
I would highly recommend that you study a few sites like <!-- m --><a class="postlink" href="http://www.asp101.com">http://www.asp101.com</a><!-- m --> and <!-- m --><a class="postlink" href="http://www.4guysfromrolla.com">http://www.4guysfromrolla.com</a><!-- m --> and <!-- m --><a class="postlink" href="http://www.asptoday.com">http://www.asptoday.com</a><!-- m --> to become more familiar with how to interface a webpage with a db and what it can do and what benefits it has.
For a good example of what to expect -
goto <!-- m --><a class="postlink" href="http://www.i-81.net">http://www.i-81.net</a><!-- m -->
click on products (on the left)
then click on I-NEWS (on the top)
then click on I-News demo version
You will be interacting with a db in realtime and seeing your changes in realtime. Have fun..THANKS!
chris<pixelmonkey>
someone, anyone, throw me an idea!
thanks
chris<pixelmonkey>
nothing is yet coming to mind, or to thread...i need ideas, have any to share?
chris<pixelmonkey>
Originally posted by pixelmonkey <SNIP.....>(IE ONLY) I'm wanting to know what tools are needed to run MS Access on my server and have people in BFE execute, edit, and save the changes. come on, i know this has been done!!!
<SNIP....>
I do it all the time. ASP is good for this. Three things need to be done -
Allow the db to read (get a recordset)
Allow the data to be edited (via webform)
Write changes to the db (update a recordset)
Now you can do more like, delete or create a record in Access also via the web. And since its ASP it doesnt matter if its IE or NS.
Take a look at <!-- m --><a class="postlink" href="http://www.asp101.com">http://www.asp101.com</a><!-- m --> and study their tutorials. I learned a lot there the first time around
hthwill the current user interface be dynamically updated depending on changes on the origonal Access file? keep in mind it's doing a relay post on the server... first the Access database, then the excell database. The database will be viewed by one person, never by the techs. I just closed a ticket number with microsoft for help on this and was told the Data Access Page would be limited to what can be done and would also be static. Does anyone disagree with this?
always looking for a loophole
chris<pixelmonkey>ok, what about ODBC? what do i need on the server and what format do i need the pages in?
slipping in and out of the lit world
chris<pixelmonkey>
Ok lets see - 1st things 1st.Yes the web server will require ODBC to be installed (I'll presume we're dealing with IIS here).
Secondly -
The web page only provides an interface to the data. It will allow you to create, edit and delete data within the db. It does not directly manipulate the data unless specifically instructed to do so.
thirdly -
Yes the interface will most likely be static UNLESS your displaying data from the db in which case it will be updated everytime the page is viewed.
forthly -
access and excel are not the same thing nor is excel a database, its a spreadsheet which has different ***ntionality altogether. You can easily manipulate the access db to display data like excel, (even with auto-updating!)
I would highly recommend that you study a few sites like <!-- m --><a class="postlink" href="http://www.asp101.com">http://www.asp101.com</a><!-- m --> and <!-- m --><a class="postlink" href="http://www.4guysfromrolla.com">http://www.4guysfromrolla.com</a><!-- m --> and <!-- m --><a class="postlink" href="http://www.asptoday.com">http://www.asptoday.com</a><!-- m --> to become more familiar with how to interface a webpage with a db and what it can do and what benefits it has.
For a good example of what to expect -
goto <!-- m --><a class="postlink" href="http://www.i-81.net">http://www.i-81.net</a><!-- m -->
click on products (on the left)
then click on I-NEWS (on the top)
then click on I-News demo version
You will be interacting with a db in realtime and seeing your changes in realtime. Have fun..THANKS!
chris<pixelmonkey>