Data entry doesn't work in Data access pages

  • Thread starter Thread starter robeito
  • Start date Start date
R

robeito

Options already set
GroupLevel:
AllowAdditions= true
AllowDeletions= true
AllowEdits= true

Despite of this, buttons navNew, navDelete, navSave and navUndo are not
enabled.

Is something missing?

(Using: MS-Access 2002, SP2, Spanish, WinXP Pro)
 
There are many reasons a DAP may not allow data entry. Check help for a
list of reasons and possible solutions. Here is some items listed in help
but I believe there are more than this.
In general, you cannot update data under the following circumstances:

a.. A query based on a many-to-many join.
b.. A query based on data marked as read-only in the database.

c.. A query that violates constraints on the base tables.

d.. A query that includes the DISTINCT keyword to exclude duplicate rows.

e.. A query based on a subquery that contains totals or aggregate
functions.

f.. A form, datasheet, or page where the underlying SQL Statement of the
record source contains a GROUP BY or COMPUTE clause.
g.. A linked table based on Transact SQL functions, because they create an
ad hoc read-only connection to the external data source.
h.. In addition, you might not be able to update specific columns in the
query results. The following list summarizes specific types of columns that
you cannot update in the result set:

a.. Columns based on expressions (such as price * quantity AS
extended_price).

b.. Rows or columns deleted by another user.

c.. Rows or columns locked by another user (locked rows can usually be
updated as soon as they are unlocked).

d.. Timestamp or image columns.

Paul D
 
Back
Top