microsoft training access course - Link an access form to the intranet

Resolved · Low Priority · Version Standard

Thu 29 Nov 2007, 10:06 Delegate Julie said...

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!

Fri 30 Nov 2007, 15:08 Trainer Pete said...

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.

Thu 28 Feb 2008, 11:16 Delegate Julie said...

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?

Fri 14 Mar 2008, 09:21 Trainer Pete said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips