Cannot edit data in forms but can in tables

  • Thread starter Thread starter Ratfink
  • Start date Start date
R

Ratfink

I have a problem!

I created a database where I can only edit the data in tables. In the forms
I created I can see the data but cannot edit the data.

I am using 2007 that I have set so the file can be opened in 2003. The data
was imported to create tables from two Excel spread sheets using the wizard.
The tables are linked together and the combined data is shown in a report.
This all works without a problem.

Now I need to edit the data, so I created several forms all of which I
cannot add, delete or edit the data.

I saw under the User and Group Permissions that under table all the
permissions have checks but under form read, update insert and delete are all
greyed out and I am unable to change this.

Does anyone know how I can make the necessary changes to edit the data in
forms?
 
It may be a problem with your query
You must have a query that joins the tables together. That query is the
source for the report
Open the query and see if you can edit the data there. Tell us if you can
edit the query
 
I have a problem!

I created a database where I can only edit the data in tables. In the forms
I created I can see the data but cannot edit the data.

I am using 2007 that I have set so the file can be opened in 2003. The data
was imported to create tables from two Excel spread sheets using the wizard.
The tables are linked together and the combined data is shown in a report.
This all works without a problem.

Now I need to edit the data, so I created several forms all of which I
cannot add, delete or edit the data.

I saw under the User and Group Permissions that under table all the
permissions have checks but under form read, update insert and delete are all
greyed out and I am unable to change this.

Does anyone know how I can make the necessary changes to edit the data in
forms?
Click to expand...

Are you basing the Forms on Queries joining the tables? If so, that may be the
problem: some multitable queries are updateable but some aren't. Normally one
would use a Form for the "one" side of the relationship and a Subform for the
"many".

Did you define Relationships between the tables after you imported them? Did
you enforce referential integrity? If you open the query datasheet, is *it*
editable? If not, the form won't be either.
 
Back
Top