Results 1 to 2 of 2
  1. #1
    vagelism22678 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Sep 2011
    Posts
    1

    Exclamation Cannot add records to the data base

    Hello to all.
    So my problem is this... I have a main form with a subform in it. When I set them threw options to dynaset I can add new records to the data base but I can not navigate threw the arrows to the previous records.


    When I set the properties of the form to snapshot ,then I can navigate to the records threw the arrows of the form but I can not add a new record.
    I know about the language barrier since the data base is in greek so the steps
    are :
    1.Click the first choise.
    2.This is the form.... Now you can experience the same situation!
    ANY IDEAS?

    I am not an expert and this is my 5 database I make.
    Please keep it simple!
    Thank you in advance

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    Use Recordset Type Dynaset (Inconsistent Updates) option instead of Dynaset.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sharing a data base
    By Cran29 in forum Security
    Replies: 3
    Last Post: 02-05-2011, 06:45 PM
  2. Data base design
    By mduplantis in forum Database Design
    Replies: 1
    Last Post: 06-05-2010, 07:30 PM
  3. I need Data Base Hlep me For My Project :(
    By cosm786 in forum Access
    Replies: 1
    Last Post: 03-24-2010, 08:46 AM
  4. update data base in access
    By freddyraf in forum Access
    Replies: 3
    Last Post: 11-06-2009, 07:01 PM
  5. Having trouble with dates in my Data Base!!!!
    By BigPhil in forum Queries
    Replies: 4
    Last Post: 02-15-2006, 12:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums