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

Editing MsSQL Data from OOo

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





PostPosted: Tue Nov 04, 2003 9:41 am    Post subject: Editing MsSQL Data from OOo Reply with quote

I have been trying to find a method for editing data in an MsSQL database from the Open Office interface.

If I create a link in a spreadsheet, a database control on a document, or even use the form pilot to dreate a form based on the source, I am not able to change values in the table.

It must be simple that I am missing. Any help?

Thanks in advance.
Back to top
dfrench
Moderator
Moderator


Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand

PostPosted: Tue Nov 04, 2003 10:09 am    Post subject: Reply with quote

Quite a common issue in this forum, if the following does not help, try a search of the forum

Check the howtos http://dba.openoffice.org/testcase/test.html
primary key required
especially remember to grant permissions to the user. Yes I know that you have just created the table but you haven't got any permissions to use it until you grant them to yourself!
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