Simple Shared Database ?

  • Thread starter Deleted member 53208
  • Start date
Log in to reply
D

Deleted member 53208

  • #1
    I'm looking for a database to use on two PC's in different locations, which can be either manually or automatically synchronised. I'm not teriffically techy so it has to be fairly simple to operate. It doesn't need to be terribly complicated as it's just to keep track of clients and the services we have provided them with, maybe about 20 user definable fields.

    Where I am struggling to find anything is with the synchronisation. We've tried Act but that really seems too complicated for what we want, and the synchronisation feature just wouldn't work in spite of spending hours on Act forums, looking through the manual. Access might be a possibility as I've used it on a single PC before, but I'm not sure about the synchronisation thing. It would be useful if the database fields could link in to a mail merge on Microsoft Word, but if it could export fields to an Excel spreadsheet then that would do instead.

    I suppose I'm looking for a kind of muppets version of Act without all the features, something that could be picked up in an hour or so.

    Any ideas would be greatly appreciated?
     
    D

    Deleted member 53208

  • #2
    Just a quick thought. On reading my posting it seems that a simple client management program rather than full database might be the answer. So with regard to the criteria in my first posting, again

    All suggestions greatfully received?
     
    Upvote 0
    O

    ozbon

  • #3
    No idea offhand.

    You could create something using OpenOffice's database. Alternatively, if those two PCs will always be online, you could do it through a web-based front-end, and run the entire thing like a website.

    I've done the latter option more times than I can count, so feel free to drop me a PM with your requirements, and I'll give you a quick quote.
     
    Upvote 0
    FireFleur

    FireFleur

    Free Member
    Oct 29, 2008
    1,880
    440
  • #5
    Could use SQLite, it has an ATTACH command that allows multiple databases to be attached, and then merged using SQL commands.

    A good book (well the only book at the mo) on SQLite is The Definitive Guide to SQLite. The index isn't great, but the book is a good read.

    If you are not SQL literate, then perhaps not the best solution, but if you are SQLite is a great little database. SQLite is finding its way into lots of my projects. The database is just one file, little configuration needed (zero), good command line app, and quite simple to interface with programs.
     
    Last edited:
    Upvote 0
    DanHarrison

    DanHarrison

    Free Member
    Apr 2, 2009
    155
    45
    Hampshire, UK
  • #6
    What immediately strikes me is that you probably want an online web-based database, which you just access with a web browser. If you don't want people to see the data, then you need strong usernames/passwords.

    Forget syncing, I've done that before and it's a complete nightmare. A central system accessible from anywhere using a web browser will save you money, LOTS of time, and be very easy to use.

    Dan
     
    Upvote 0
    MartCactus

    MartCactus

    Free Member
    Sep 25, 2007
    983
    214
    London, England
  • #7
    DanHarrison said:
    What immediately strikes me is that you probably want an online web-based database, which you just access with a web browser. If you don't want people to see the data, then you need strong usernames/passwords.

    Forget syncing, I've done that before and it's a complete nightmare. A central system accessible from anywhere using a web browser will save you money, LOTS of time, and be very easy to use.

    Dan
    Click to expand...

    I'd agree with this - assuming both users of the database will have internet access.

    Synchronisation can be complicated, especially where you have 2 or more users updating the data. Whereas with a web database you actually only have one database - so if I add a new record, that is then available for the other user. IF you have 2 separate databases that you synchronize, you have problems if you've both updated data - it has to decide (or you have to tell it) which of the updates to copy to eachother.
     
    Upvote 0
    JohnGrove

    JohnGrove

    Free Member
    Sep 15, 2009
    48
    10
  • #12
    Two options come to mind, both of which I've implemented for clients.

    If you have a network and a spare pc you can allocate remote desktop access to that pc and install a MS Access front end on it. The data backend would sit on a server/workstation within your network allowing you both to link to the live data.

    The other option is to install an open source CRM solution on one of your machines. I support SugarCRM and would be happy to talk you through it.
     
    Upvote 0
    D

    Deleted member 53208

  • #13
    A big thank you to everyone for your ideas. I'm thinking that the online database option might be the way to go. I don't want to host it myself as if I am on holiday or out of the office and my PC goes wonky (technical term) then my business partner would be in the poo (another technical term) so because of that and the fact we have both used Google docs in the past I think I need to find a good, cheap reliable online database.

    Any suggestions?

    Anyone?
     
    Upvote 0
    DanHarrison

    DanHarrison

    Free Member
    Apr 2, 2009
    155
    45
    Hampshire, UK
  • #14
    Providing you had a data system developed for you, any standard web hosting service would do the job (one that has php and MySQL). There are some off the shelf packages for creating databases, or you can have one custom made for you.

    So that I can help more, exactly what information are you looking to store? And what are you doing with that information? (Feel free to PM me if you don't want it public).

    Dan
     
    Upvote 0
    Log in to reply

    Latest Articles

    Join UK Business Forums for free business advice
    Top Bottom
    Community
    Articles
    Menu