This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi, I created a database in Access, saved & ran it.. But it will only let me add only 1 record, & not another.. Is there a way to fix this?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Make sure you have set the following properties:
AllowAdditions = True
AllowEdits = True
AllowDelete = True
If that doesn't work, try creating a new form using the wizard and see if that allows you to add new records.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
How are you trying to add a new record and what is telling you that you can't.
It does look like the add new record button on the Navigation bar is not active which would indicate that Allow Additions is set to off or you have an issue with your primary key.
What is the Recordsource of the form? What is the structure of the table? How are you opening the form? Can you enter new records directly into the table? Are the proper permissions set for the folder the app is in?We really need more info to help diagnose.
Make sure you have set the following properties:
AllowAdditions = True
AllowEdits = True
AllowDelete = True
If that doesn't work, try creating a new form using the wizard and see if that allows you to add new records.
Cool, thanks. Where can I find those settings? I looked everywhere in the property sheet, but no luck finding it..
How are you trying to add a new record and what is telling you that you can't.
It does look like the add new record button on the Navigation bar is not active which would indicate that Allow Additions is set to off or you have an issue with your primary key.
What is the Recordsource of the form? What is the structure of the table? How are you opening the form? Can you enter new records directly into the table? Are the proper permissions set for the folder the app is in?We really need more info to help diagnose.
It happens every time I try to create a new database file. I design the table, save it. but it wont let be add more then 1 record.
If this happens with every table and every file, I suspect you don't have the correct permissions for the folder you are trying to create the file in. you need to check those permissions.