Link to home
Start Free TrialLog in
Avatar of TicketShine
TicketShine

asked on

MS Access 2010 Web Database

**UPDATE**
OK - After doing some more tests I've got a more specific problem. So the problem lies within the query. After creating sample queries and forms, I realize that the problem lies within the "one" side of the one to many relationship. I  can edit the "many" information, however, the "one" information is locked. Why is this happening, and how do I fix it?
Thanks!
**

Hello!
I recently published a MS Access 2010 web database to sharepoint (office 365), and the web database is showing several problems that are were not present in the client version of the web database. Here is my problem:

The forms that are based off of tables work as they are supposed to. However, the fields in the forms that are based off of queries are read-only. I need to figure out why they are read-only, fix the problem, and allow them to be edited. I have attached a photo so that you can see a visual of my problem.

I think the problem lies within either the queries or the forms, more specifically the form properties. Here's some specifics:

Form Properties:

-Record source is the correct query
-Allow Additions: No
-Allow Deletions: No
-Allow Edits: Yes

Field Properties:
-Enabled: Yes
-Locked: No

Let me know if I am missing some information!
Thanks!
WebFieldReadOnly.jpg
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

After creating sample queries and forms, I realize that the problem lies within the "one" side of the one to many relationship. I  can edit the "many" information, however, the "one" information is locked. Why is this happening, and how do I fix it?
If you are representing one-to-many relationships through forms, you generally do this with parent/child forms (i.e. subforms). Basing a form on a query that combines the parent and child records will almost always render the form to be non-updateable.
ASKER CERTIFIED SOLUTION
Avatar of Richard Daneke
Richard Daneke
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial