| View previous topic :: View next topic |
| Author |
Message |
HiimAl
General User
Joined: 07 Aug 2007
Posts: 16
|
 Posted: Mon Oct 12, 2009 10:55 am Post subject: Can't add new records to table in OOo 3.1 |
 |
|
I am trying to use a existing .odb file that was created on OOo 3.0.1. It was connected to a Microsoft Access database. The original flash drive I was using was stolen, so I wrote OOo 3.1 to a new drive. The database opens fine, I can see all the tables, queries, and forms. The table opens correctly, but if I try to add a record, it tells me "error inserting a new record". No other information is given.
I verified that the table does have a primary key. I even tried to create a new Open database, connect to the Access database, and it still will not let me add a new record.
Is this a issue with 3.1? Any help would be great.
Thanks. |
|
| Back to top |
|
 |
HiimAl
General User
Joined: 07 Aug 2007
Posts: 16
|
| Posted: Wed Oct 14, 2009 1:17 pm Post subject: |
|
|
| anyone? |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Wed Oct 14, 2009 1:52 pm Post subject: |
|
|
Hello
I don't knew an answer, only a question.
Can you add a record when you have open a table and not a form?
Romke |
|
| Back to top |
|
|
HiimAl
General User
Joined: 07 Aug 2007
Posts: 16
|
| Posted: Thu Oct 15, 2009 9:25 am Post subject: |
|
|
| This is when I try to add a record to the table. I have not tried to use the form. |
|
| Back to top |
|
|
r4zoli
Super User
Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary
|
| Posted: Fri Oct 16, 2009 6:17 am Post subject: |
|
|
You opened file on usb drive?
Try it on you main HDD, any differences?
If you opens odb file on usb keys, you data in danger, it can be lost. Use hdd and when finished copyodb file to usb key. |
|
| Back to top |
|
|
HiimAl
General User
Joined: 07 Aug 2007
Posts: 16
|
| Posted: Fri Oct 16, 2009 6:59 am Post subject: |
|
|
| r4zoli wrote: | You opened file on usb drive?
Try it on you main HDD, any differences?
If you opens odb file on usb keys, you data in danger, it can be lost. Use hdd and when finished copyodb file to usb key. |
I am trying to open the file from the HDD. |
|
| Back to top |
|
|
r4zoli
Super User
Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary
|
| Posted: Fri Oct 16, 2009 11:19 pm Post subject: |
|
|
| Your access database table has a primary key? |
|
| Back to top |
|
|
HiimAl
General User
Joined: 07 Aug 2007
Posts: 16
|
| Posted: Mon Oct 19, 2009 8:40 am Post subject: |
|
|
| r4zoli wrote: | | Your access database table has a primary key? |
Yes it does. I even tried to change the key to a different field and it made no difference. |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Mon Oct 19, 2009 1:44 pm Post subject: |
|
|
Hello
You wrote it is an Access database.
Can you edit the table in MSAccess?
Do you have an database engine for MS Access?
Romke |
|
| Back to top |
|
|
HiimAl
General User
Joined: 07 Aug 2007
Posts: 16
|
| Posted: Wed Oct 21, 2009 12:49 pm Post subject: |
|
|
| Yes, it works fine in MS Access |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
| Posted: Thu Oct 22, 2009 1:48 am Post subject: |
|
|
Hello
I assume you knew the difference between a real table in a database and a table grid in a form. See my first question.
Maybe you can ask this question in the other English forum and try toget there an answer.
Romke |
|
| Back to top |
|
|
|
