Slashdot Mirror

← Back to Stories (view on slashdot.org)

Sharing MS-Access Databases, Efficiently?

Posted by Cliff on from the doing-the-improbable dept.

codewizard asks: "Ours is a bank and we have a bunch of MS-Access databases(>50) which are being used by around 50 users around the globe on a daily basis. The set of databases are stored on a SAMBA share and each user accesses from the mapped drive. As expected, sharing conflicts arise and multiple users are unable to access at the same time. So, we proposed having multiple folders on SAMBA each of which would have all the databases and the users logon script would determine where their mapped drive points to. This led to synchronisation issues (when a change is required in one of the master databases, we need to manually synchronise all other folders) and increase in storage size in SAMBA. Anyone have any other ideas on how you would have gone about sharing these MS-Access databases?"

6 of 98 comments (clear)

  1. Re:Isn't the answer obvious? by WasterDave · · Score: 5, Funny

    Fucking breathtaking, innit. Made all the worse by being prefixed with "codewizard asks".

    --
    I write a blog now, you should be afraid.
  2. use MySQL by alonsoac · · Score: 2, Funny

    One thing you could do is drop Access and use MySQL or keep Access to feed the data but have frequent exports into MySQL which are in turn queried by all the people around the world, it would work if most of them only need to take a look and not change things.

    Maybe even my company can help you with this.

    http://managedaffiliateprograms.com/contact.php

  3. Re:Isn't the answer obvious? by trentfoley · · Score: 4, Funny

    In this case, "codewizard" is referring to the new Microsoft Access Code Wizard. Apparently, someone at the bank clicked on the "debug" button in the error message dialog they got when their Access database was locked. This, of course, launched the "codewizard" which promptly generated and submitted this Ask Slashdot post.

    It could happen... right?

  4. Which bank? by seanmeister · · Score: 5, Funny

    Seriously, I want to know. Because if it's MY bank, our relationship is over.

    I mean, Access - come ON!

  5. RUN by sohp · · Score: 2, Funny

    Please tell me what bank you are working at so I can be sure I never put my money in an account there.

  6. Re:SQL Server by delus10n0 · · Score: 2, Funny

    Awesome! I have no idea why someone modded me "Overrated", but thanks man. I appreciate it. My post certainly was that!

    --
    Not All Who Wander Are Lost