backend/frontend?

[cmoss]

I have created a form that I want to share with other people. They will never add or change any of the data - they will only use the form as an information source. I need to be able to access the database to add/change information.

What is the best way to do this?

 

[ThreeCrow]

If do not want the other people to edit the database, you sould Create another Form that is for viewing only. For all of the data controls set the Enable property to No and the Lock property to Yes, this will prevent any changes. And maybe a few ComboBoxes to filter through the Records.

The Form that you have now, use for data entry and changes.

There are a number of ways' to do this this is the simplist

 

[MarkK]

The answer will depend on where the "other people" are and how frequently you need to update the data. Extremes...
1) Annual updates with users in remote cities
2) Hourly updates with users on the same computer
Easy to see that these call for significantly different solutions.

 

[cmoss]

Thank you both for your posts! The information would be updatedabout once a month and is for use in our help desk phone room as well as an off site help desk phone room.

ThreeCrow - If I went with your suggtestion, I would replace the "user" form after every update, correct?

 

[ThreeCrow]

No, the user (those who read only) will use the View only Form. to view the Records that you use your first Form to Enter/Change data in your tables.

Example of Setup:

Data Entry/Change Form Named frmCustomersEntry
under laying table tblCustomers

Data View Only Form Named frmCustomersViewOnly
under laying table tblCustomers
Place this on user Front End

The Forms are (for the most part) the same except that one is Data Entry/View, and the other is View Only. When you Enter or Change your data
it will display in the user Form.