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 this be done with OpenOffice Base?

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


Joined: 07 May 2009
Posts: 2

PostPosted: Thu May 07, 2009 5:14 am    Post subject: Can this be done with OpenOffice Base? Reply with quote

Hi all,

Firstly, I'd like to explain what's going on.
We have a small office doing international trading here.

We need a system where people can input forms and generate printable Sales Contracts, Invoices, Packing Lists, etc. The data collected would also be viewable to keep track inventory and shipping schedules.
However, the data will be shared amongst 11 people on 11 different computers. They need to continuously update and view the database.

My question is, can all these be done with OpenOffice Base? Can we have multiple users simultaneously access and edit the database? I have concerns because after a bit of Googling, some people said that you can't have multi-user feature in an OpenOffice database.

If that can't be achieved, can you give a recommendation on what to use?
Solutions like SAP and such are just way too complicated (and too large of a scale) for us to implement.
We prefer an open source solution (mainly due to budget) that doesn't require too steep of a learning curve, mainly because our IT guy is a fresh graduate Sad

Thanks very much in advance.
Back to top
View user's profile Send private message
keithclark1966
OOo Enthusiast
OOo Enthusiast


Joined: 18 Jan 2007
Posts: 189

PostPosted: Thu May 07, 2009 6:14 am    Post subject: Reply with quote

You could do as I do. Use Base as a front end to a MySQL database. Have the MySQL database located on a central server and have Base access that database from users PCs.

Hope that helps.

Keith
_________________
Open Office 3.0 under Ubuntu 9.04, XP and Vista
Back to top
View user's profile Send private message
officefish
Newbie
Newbie


Joined: 07 May 2009
Posts: 2

PostPosted: Thu May 07, 2009 6:26 am    Post subject: Reply with quote

Thanks for the reply!
Do you know any guide to help/guide us in connecting Base to MySQL?
It doesn't have to be step by step, but a rough idea would really help a lot.
Back to top
View user's profile Send private message
keithclark1966
OOo Enthusiast
OOo Enthusiast


Joined: 18 Jan 2007
Posts: 189

PostPosted: Thu May 07, 2009 6:31 am    Post subject: Reply with quote

http://wiki.services.openoffice.org/wiki/Connect_MySQL_and_Base

I believe that is a good starting point.

Keith
_________________
Open Office 3.0 under Ubuntu 9.04, XP and Vista
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