Julie has attended:
Access Advanced course
Access VBA course
Link an access form to the intranet
I have a database for measurement requests and all most of the users need to be able to do is fill in one form to submit a request. Ideally this would be linked to our company intranet.
Is there a simple way to do this? Previously i have made a backend database and then got everyone to download a copy of the front end to their desktop but in this instance that is not appropriate due to the number of users. I could have one copy of the front end on our server for everyone to use but i'm concerned about multiple users of one instance causing problems.
Any ideas would be appreciated!
RE: Link an access form to the intranet
Hi Julie, Thank you for your post, In answer to your question, I would suggest you try a Data Access Page, this can be edited by any number of users on your company intranet, and will not cause problems of multiple users entering data simultaneously.
To create a Data Access Page from a form, go to menu item File, Save As and from the Type option drop down choose Data Access Page, this will create a separate HTML document of your Form which can be used to enter and view data. The entries will update your database form. ... I hope that helps, best regards Pete.
RE: Link an access form to the intranet
The form in the database has a piece of code in the save and send button which sends the originator of the request and email to give them their request number and a second email to the metrology manager to notify him of the request.
If i do it as a data access page will this still work?
RE: Link an access form to the intranet
Hi Julie, I really cant say without seeing the whole thing, a data access page is written in HTML, so if the piece of code is able to be re-written by Access into HTML there is no reason why it should not work.
All I can suggest is that you create a copy of your database, and then try it out on the copy, that way if it does not work or something goes wrong then you have lost nothing in the long run. best regards Pete
