S
S Holubar
Hi I am a new user to this group. I am a Surgery resident and I've used
Access for some years at an intermediate level and am now working on a OR
case assignment db and patient lists to be accessed via Data Access Pages
over the Web and have run-in to some trouble and was looking for some help.
The pages are at http://www.anastomosis.net/Teams.htm. Importantly the pages
need to be dynamic so that anyone can update them from any computer. I have
no experience with ASP or SQL which is why I have chosen DAP's.
Question #1 (re: remote server): Currently the DAP's are on my remote server
but the source *.mdb is on my desktop (it works this way i.e. I can access
and edit the data from IE). I have placed a copy of the *.mdb on my remote
server in the fpdb folder. However when I try to change the DAP Connection
to the remote *.mdb it points to a temporary file on my harddrive instead
of the URL, and then it dosen't work anyway. How do I properly move my *.mdb
to my remote server so that it will work with my DAP's? Do I need to export
to an SQL instead? How do I do that?
Question #2 (re: dynamic pages): Although I can access and edit the data in
the DAP pages from IE on my desktop PC, when my collegue tried from home the
changes he made are not retained in the db. Is this a function of the *.mdb
being on my desktop? Will this resolve when I migrate to the Server?
Question #3 (re: expression building): I have a column where I would like to
enter the date and then Access automatically converts the date to a running
number. For ex. a patient is admitted on 4/1/05 should change to 0 when
entered and then the next day it will show up as 1, the next day as 2 etc.
Question#4 (re: LimitToList): I've made nice lookup columns in my table
using the LimitToList set to "no" so that users can enter data not in the
list (when using the datasheet or Form). However when I use the DAP the
LimitToList function is lost i.e. users can only choose from the Combo-box.
How do I retain this functionality so that un-listed values can be entered
in the DAP?
TIA for any and all suggestions,
S Holubar
Access for some years at an intermediate level and am now working on a OR
case assignment db and patient lists to be accessed via Data Access Pages
over the Web and have run-in to some trouble and was looking for some help.
The pages are at http://www.anastomosis.net/Teams.htm. Importantly the pages
need to be dynamic so that anyone can update them from any computer. I have
no experience with ASP or SQL which is why I have chosen DAP's.
Question #1 (re: remote server): Currently the DAP's are on my remote server
but the source *.mdb is on my desktop (it works this way i.e. I can access
and edit the data from IE). I have placed a copy of the *.mdb on my remote
server in the fpdb folder. However when I try to change the DAP Connection
to the remote *.mdb it points to a temporary file on my harddrive instead
of the URL, and then it dosen't work anyway. How do I properly move my *.mdb
to my remote server so that it will work with my DAP's? Do I need to export
to an SQL instead? How do I do that?
Question #2 (re: dynamic pages): Although I can access and edit the data in
the DAP pages from IE on my desktop PC, when my collegue tried from home the
changes he made are not retained in the db. Is this a function of the *.mdb
being on my desktop? Will this resolve when I migrate to the Server?
Question #3 (re: expression building): I have a column where I would like to
enter the date and then Access automatically converts the date to a running
number. For ex. a patient is admitted on 4/1/05 should change to 0 when
entered and then the next day it will show up as 1, the next day as 2 etc.
Question#4 (re: LimitToList): I've made nice lookup columns in my table
using the LimitToList set to "no" so that users can enter data not in the
list (when using the datasheet or Form). However when I use the DAP the
LimitToList function is lost i.e. users can only choose from the Combo-box.
How do I retain this functionality so that un-listed values can be entered
in the DAP?
TIA for any and all suggestions,
S Holubar