Data Access Page won't allow new entry 1

[SydneyDylan]

I have devised a database with roughly 10 tables. From three of these tables one query is created.

I use this query to create a access page, however I cannot update it.

Any suggestions would be greatly appreciated.

THANKS!

 

[MichaelRed]

Generally, this error occurs where there are (or at least COULD BE) multiple records in one or more of the tables affected by the update. This, in turn, is most often the case when an outter join is present in the query. You would need to re-structure the source(es) to have un-ambigious record references.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[FancyPrairie]

Try setting the DataEntry property of the Page to True. To get to the Page properies, select the Restore Window icon (so your form/page is not maximized). Then click on the title bar. The properties for the Page will be shown.