Beginner Question about forms and database

[Lourry]

Hello All,

This is me now

OK. I need to create this form in Accss that links to a Oracle database which has the tables for the records. The backend part is already setup (the Oracle database) now I need to create a form that access the database to modify/add/delete records. So here are my questions:

1) In "Design View" I have put in controls (such as textbox, combo box etc...). When a user use this form in "Form View", wouldn't they be able to change the design of it by just simply going to "Design View"?

2) When I create listbox/combo box, I created tables in Access to populate these boxes. When a user choose one of its values, will it be saved to the Oracle database? or back to the Access tables I created just to populate the boxes?

Thanks in advance!!
Lory

 

[The_Doc_Man]

1) In "Design View" I have put in controls (such as textbox, combo box etc...). When a user use this form in "Form View", wouldn't they be able to change the design of it by just simply going to "Design View"?

If the Access database is shared, implement security via workgroups so your users cannot change the forms. Search this forum and Access Help for "workgroup security" to find articles on same.

If the Access database is distributed, convert it to an MDE file. Search this forum and Access Help for "MDE" and/or "conversion to MDE" to find articles on same.

2) When I create listbox/combo box, I created tables in Access to populate these boxes. When a user choose one of its values, will it be saved to the Oracle database? or back to the Access tables I created just to populate the boxes?

If the tables in Access are purely for lookup but the form displays its primary content from ORACLE, you will save the record and fields to ORACLE.

If your "live" records do not originate from ORACLE (form's overall record source is not linked to your ORACLE db), you have a major design problem on your hands that might require more space than this forum allows.

 

[Lourry]

Thanks!

The form is for distribution so I'll lookup on conversion to MDE.

All of the form's field is to be linked to an Oracle database. I just create the tables in Access for populating the listboxes. This wouldn't have a conflict with the value selected being saved to the Oracle database right?

Thanks again!
-Lory