Data entry denied in a query.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I used a database in multiple PC and now I cannot make any entry in the query
or forms.
I changed the Recordset type to Dynaset (Inconsistent Updates) but now I
cannot scroll though the records, only the last enry is dispalyed. What did I
do wrong?
I am a novice and I only use macros, I have no experience in script or
programming.
I joined a query and a table but I cannot do any data entry when I change the
Recordset type to Dynaset (Inconsistent Updates) it will work but when I
enter the ID number the rest of the record, such as the name will not be
displayed, This was warking fine in the past.

Quinto

.

Relevant Pages

  • Re: Recordset Type Issue
    ... > recordset type was set on Dynaset and I changed it to Dynaset ... > to recordset type to (inconsistent updates) and work through the bugs. ... I'm not sure if your problem has to do with updatability or not. ...
    (microsoft.public.access.forms)
  • RE: Error message: "this recordset is not upateable"
    ... Go to your form properties and find the property "Recordset Type". ... It probably list the type as Dynaset. ... (Inconsistent Updates) ...
    (microsoft.public.access.forms)
  • RE: Q. I delete from table, and the query still shows the record !
    ... I had the same problem a while back, and was able to determine that problem came from the recordset type of the query being Dynaset. ... So, I deleted them from the tables (in my split database), and then go ...
    (microsoft.public.access.formscoding)
  • Re: Data entry denied in a query.
    ... I am really intrigue by MS Access and I want to leran more. ... I changed the Recordset type to Dynaset (Inconsistent Updates) but now I ...
    (microsoft.public.access.queries)
  • Re: Back end database lock-up
    ... If your query is a 'select' query and it has multiple tables in it and ... scan down the properties and find 'recordset type' ... Default Record Locking: No Locks ... Keith Wilby mentioned rights. ...
    (comp.databases.ms-access)