Hi all,
I am stuck with a little but annoying problem: I need to create a Data Access Page for one of the tables, but every time I try to create it the DAP comes as read-only.
I searched the Internet and found that one of the reasons for a "read-only" page could be the grouping. I removed the grouping, yet the results are the same.
Is there a limitation in Access that defines when DAP is created as read-only and when it is editable? Is there a good comprehensive tutorial/Help/FAQ/something that explains it?
Some background: the source table is actually based on a complex query, which takes its data from 5 different tables. From what I understand this query is too complex on its own and as such could not be edited. So at this stage my solution is creating a table based on that query, modifying the data and pasting it back to the initial source table. It all looks fine in theory, but I am stuck with the data access page (I cannot use the form, unfortunately).
Thanks in advance for your help and ideas
Best,
Michael
I am stuck with a little but annoying problem: I need to create a Data Access Page for one of the tables, but every time I try to create it the DAP comes as read-only.
I searched the Internet and found that one of the reasons for a "read-only" page could be the grouping. I removed the grouping, yet the results are the same.
Is there a limitation in Access that defines when DAP is created as read-only and when it is editable? Is there a good comprehensive tutorial/Help/FAQ/something that explains it?
Some background: the source table is actually based on a complex query, which takes its data from 5 different tables. From what I understand this query is too complex on its own and as such could not be edited. So at this stage my solution is creating a table based on that query, modifying the data and pasting it back to the initial source table. It all looks fine in theory, but I am stuck with the data access page (I cannot use the form, unfortunately).
Thanks in advance for your help and ideas
Best,
Michael
