Database Update

  • Thread starter Thread starter Jalal
  • Start date Start date
J

Jalal

Why we cannot update database through forms built on one to many relations
tables?
 
If the form is based on a multi-table query, try opening the query. Can you
update the records in the query?

NO: For a list of possible causes, see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

YES: Then some of the form properties are set wrongly.
Datasheet Type should Dynaset (not the Inconsistent Upates one.)
AllowEdits must be Yes.

If neither of those help, it may be to do with Access security, or Windows
permissions.
 
It is a form based on to related (One to many) tables not a query based form
 
I don't understand.

If the form is based on multiple tables, but not a saved query, then
presumably you have a SQL statement in the form's RecordSource? Open that in
Datasheet view, and see if the results are read-only.
 
How is that possible? If you've got more than one table involved, you have
no choice but to use a query!

Or do you perhaps have a form with a subform on it?
 
Yes Sir. It is a form with a subform

Douglas J. Steele said:
How is that possible? If you've got more than one table involved, you have
no choice but to use a query!

Or do you perhaps have a form with a subform on it?
Click to expand...
 
Which form is not updatable: the main form or the subform?

Open that one (either the main form, or the subform) in design view.
Open the Properties box.
Tell us what settings you have for the properties, such as:
RecordSource
AllowEdits
Recordset Type
 
The unupdatable form is the subform.
Main form record source; main table, allow edit; yes and recordset type;
Dyanset.
Subform record source; subform table, allow edit; yes and recordset type;
Dynaset
 
Perhaps the main form's AllowEdits is No. That would block the use of the
subform too.

Otherwise I don't know what's going on.

If the subform is bound directly to a table in this database (not linked
from somewhere else), and the controls are not locked or disabled, and the
form properties are as you say, and there is no Access security implemented,
and the folder where the database exists is writable and you have
permissions for it, and there is no code running in events that would cancel
or disallow the entries, I don't know what to suggest.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
Access Access, Error Due to Versioning Differences 0
Subform with subform properties 0
Expand/Collaspe feature in Access2007 4
Update Two Tables Using One Form Contents 0
How do I invoice a cost to a custom built MS Access Accounting Database? 0
command buttons access 2007 2
Access Overflow error 3

Back
Top