The master table in the database will not let me change the data. How do I make it so that it will allow me to change the data

I can’t change the data in either my master table or the form created from it. I only have the master table and the one form. What can I do to make the database allow me to change the data. The table was created from an import of data from Microsoft Access.

Hello,

Not sure what kind of table you created. An actual table or one linked to data. Please provide the steps taken to generate the table in question.

Also when asking, it may help to know OS, LO version used & in this case the type database in use.

Did you receive a message when importing:
"No primary key
In this database, a unique index or primary key is required for record identification.
You will not be able to enter data into the table until it meets one of these two structural conditions.
Should a primary key be generated now?

Yes | No | Abort, stop"

You need one primary key.

I’m not sure what I type of table I created either. I am using Windows 10 and I am trying to use the LibreOffice Base. I created the table a while ago and I’m not sure if I imported it from Microsoft access directly into a table or what I did.

I still have the Microsoft Access file so maybe I should start over and create a new table and do it right this time. I did get the message that I needed a primary key and I answered yes but I just checked the table and there isn’t a field with any kind of key.

Would you please give me the correct steps to create a new database in LibreOffice using the Microsoft Access database. My Microsoft office is version 2010 and I will start again. I can always create a new form later.

I found the video of how to create a database from Access so I will try that. Thank you all for your help.

Hello,

The database in use is identified in lower left corner of main screen such as HSQLDB embedded.

Instead of recreating from scratch try this. First make a backup (copy) of the Base file. Not only for this but always have a backup. Now edit the table (right click table name & select edit). Add a new field something like ‘ID’ or similar. Set type as Integer and set autovalue property to Yes. Select any other line & you should see a key symbol to the left of the new field. Save the table & test.

thank you so much - I have success and the trick was the primary key.