OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Can't add new records to table in OOo 3.1

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
HiimAl
General User
General User


Joined: 07 Aug 2007
Posts: 16

PostPosted: Mon Oct 12, 2009 10:55 am    Post subject: Can't add new records to table in OOo 3.1 Reply with quote

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
View user's profile Send private message
HiimAl
General User
General User


Joined: 07 Aug 2007
Posts: 16

PostPosted: Wed Oct 14, 2009 1:17 pm    Post subject: Reply with quote

anyone?
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Oct 14, 2009 1:52 pm    Post subject: Reply with quote

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
View user's profile Send private message
HiimAl
General User
General User


Joined: 07 Aug 2007
Posts: 16

PostPosted: Thu Oct 15, 2009 9:25 am    Post subject: Reply with quote

This is when I try to add a record to the table. I have not tried to use the form.
Back to top
View user's profile Send private message
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Fri Oct 16, 2009 6:17 am    Post subject: Reply with quote

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
View user's profile Send private message
HiimAl
General User
General User


Joined: 07 Aug 2007
Posts: 16

PostPosted: Fri Oct 16, 2009 6:59 am    Post subject: Reply with quote

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
View user's profile Send private message
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Fri Oct 16, 2009 11:19 pm    Post subject: Reply with quote

Your access database table has a primary key?
Back to top
View user's profile Send private message
HiimAl
General User
General User


Joined: 07 Aug 2007
Posts: 16

PostPosted: Mon Oct 19, 2009 8:40 am    Post subject: Reply with quote

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
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Oct 19, 2009 1:44 pm    Post subject: Reply with quote

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
View user's profile Send private message
HiimAl
General User
General User


Joined: 07 Aug 2007
Posts: 16

PostPosted: Wed Oct 21, 2009 12:49 pm    Post subject: Reply with quote

Yes, it works fine in MS Access
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu Oct 22, 2009 1:48 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group