Ask Your Question
0

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

asked 2018-12-29 17:44:09 +0200

funstepper gravatar image

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.

edit retag flag offensive close merge delete

Comments

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.

Ratslinger gravatar imageRatslinger ( 2018-12-29 18:13:07 +0200 )edit
1

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.

ebot gravatar imageebot ( 2018-12-29 19:29:05 +0200 )edit

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.

funstepper gravatar imagefunstepper ( 2018-12-29 21:14:43 +0200 )edit

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

funstepper gravatar imagefunstepper ( 2018-12-29 22:27:55 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-12-29 22:01:35 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more

Comments

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

funstepper gravatar imagefunstepper ( 2018-12-30 14:05:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-29 17:44:09 +0200

Seen: 29 times

Last updated: Dec 29 '18