If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DAPs, migration from Desktop to remote Server, dynamic pages, DAP LimitToList?
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 ( 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 ( 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 ( 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 ( 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
O2K CW Remote Mail Config with Multiple Accounts | dave | General Discussion | 0 | August 25th, 2004 05:48 PM |
Business Contact Manager 2003 | Nevin | Installation & Setup | 3 | August 1st, 2004 09:41 PM |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |
standalone Access 2003 & SQL Server 2000 Desktop Engine | Jim Shores | New Users | 1 | May 10th, 2004 06:20 AM |