Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Desktop vs Web Application

  • 17-08-2018 11:12AM
    #1
    Danger Fourpence
    Registered Users, Registered Users 2 Posts: 190 ✭✭


    Not quite sure where this one sits so apologies from the off if I have the wrong forum.

    I have a desktop application that I use which writes to a database. There is a single write or read operation at any one time. I'd like to alter the application so that a number of users can use it at once. The way I've gone around this is by having the application on a single PC and sharing the drive location on that PC to other users but because there is only a single read/write operation allowed at any one time this slows it down.

    Is there a better way around this? Is it possible to create an "offline" web application or do I need to change the DB I'm working with?


Comments

  • #2
    Tweeter
    Registered Users, Registered Users 2 Posts: 252 ✭✭Tweeter


    Just give each user a copy of the desktop application to install on their own PC


  • #3
    Danger Fourpence
    Registered Users, Registered Users 2 Posts: 190 ✭✭Danger Fourpence


    Tweeter wrote: »
    Just give each user a copy of the desktop application to install on their own PC

    They all need to be able to access the same DB though.


  • #4
    Tweeter
    Registered Users, Registered Users 2 Posts: 252 ✭✭Tweeter


    That's just a matter of changing the connection string to the database which is probably setup currently to be localhost


  • #5
    srsly78
    Registered Users, Registered Users 2 Posts: 7,157 ✭✭✭srsly78


    A lot depends on what database is being used. Microsoft access doesn't really work well with multiple users.


  • #6
    Danger Fourpence
    Registered Users, Registered Users 2 Posts: 190 ✭✭Danger Fourpence


    srsly78 wrote: »
    A lot depends on what database is being used. Microsoft access doesn't really work well with multiple users.

    Yeah but it should be able to work with a handful of users?


  • Advertisement
  • #7
    Danger Fourpence
    Registered Users, Registered Users 2 Posts: 190 ✭✭Danger Fourpence


    Tweeter wrote: »
    That's just a matter of changing the connection string to the database which is probably setup currently to be localhost

    If the master database resides on a single machine then the connection string would need to be different for each deployment, no?


  • #8
    bonzodog2
    Registered Users, Registered Users 2 Posts: 6,335 ✭✭✭bonzodog2


    Danger Fourpence wrote: »
    If the master database resides on a single machine then the connection string would need to be different for each deployment, no?

    You could put an entry in the hosts file on each machine


  • #9
    srsly78
    Registered Users, Registered Users 2 Posts: 7,157 ✭✭✭srsly78


    Danger Fourpence wrote: »
    Yeah but it should be able to work with a handful of users?

    I haven't tried access in a long time. You can just download a proper database for free instead. Then can use access as a gui with linked tables.


Advertisement