Data Entry Form

[Dohey]

I am designing a Data Entry form to give several departments the ability to enter transfer requests and save them so my department can see them and enter them into our finance system. I have a test form created and it is somewhat ready for testing. How can I send this out to the departments and how do I ensure that they can't change my tables or the design of the form?

Also, I want to set up a link on our web-site for this form so the departments can access it through the site. Is this possible or should I use VB (or something similar) for a front end?

Any help on this would be greatly appreciated.

Thanks in advance

 

[Joe4]

To test the data entry form, I would simply either:

1.) Create a copy of the database and let them test that.

2.) Create copies of the underlying tables of the entry form. Then either have the entry form update the copies of the tables, or leave the entry form as is and overwrite the data in tables with the copies you created when they are finished testing.

I have not done much with linking Access to web pages. Someone else will have to field that part of the question. I know you can do it, though (that is what the Pages object is for).
This message was edited by jmiskey on 2002-12-12 14:57