+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
Office Software Thread, Connecting to Access DB in Technical; I have a piece of software that connects to a MS DB on a 2008 server (its called food in ...
  1. #1

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,841
    Thank Post
    25
    Thanked 91 Times in 71 Posts
    Rep Power
    51

    Connecting to Access DB

    I have a piece of software that connects to a MS DB on a 2008 server (its called food in focus). Its locking people out when they log out and back in...or if there are 20 or so people using it. I was told it could be the MS Access connection limit which I thought was in the ODBC connectors in the control panel but cant find the limiter.. anyone know where it might be or if its something else.

  2. #2

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    @Simcfc73 did you have any luck with this - we're also seeing issues with Food in Focus, MDB is stored on a SAN/NAS device served by CIFS.

    Cheers

    Will

  3. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    Hmm.. I'm missing the point here, but where does Access come into play if you're connecting to an MS SQL database?

    MS Access has a built in concurrent connection limit, just as Windows XP or Windows 7 do too for example. This is why Windows Server with x amount of CALs and MS SQL is the way forward so there should be no connection limitations.

  4. #4

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    It's not an MS SQL database, it's an access mdb file stored on a network share, on a server OS (in my case solaris based OS sharing via CIFS)

  5. #5

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    Also - it is possible to convert an MS Access database into SQL (google this), but seeing as it's a product you've purchased I'd go back to them first.

  6. #6

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    Quote Originally Posted by Michael View Post
    Also - it is possible to convert an MS Access database into SQL (google this), but seeing as it's a product you've purchased I'd go back to them first.
    Have done that - they have previously blamed storage back end... I've now tried 3 different storage backends...

  7. #7

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    Quote Originally Posted by Willott View Post
    Have done that - they have previously blamed storage back end... I've now tried 3 different storage backends...
    It's without a doubt the MS Access DB concurrent connection limitation and not your server. I presume the share itself is set to unlimited (by default)?

    It is odd they've decided to use MS Access and not SQL Express (which is free), considering it's to be used in a school.

  8. #8

    Join Date
    Oct 2005
    Location
    hey hey hey, stay outta my shed. STAY OUT OF MY SHED.
    Posts
    1,062
    Thank Post
    250
    Thanked 207 Times in 158 Posts
    Rep Power
    110
    I don't know what's odd about it - shameful certainly but not odd. Far too much educational software is made by people who appear to have never actually used a computer before in their lives. Or at best, have what the charitable person might call "unconventional views" about how to build applications.

  9. #9

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    No limits on shares, and I had the same thoughts... unless @Simcfc73 found a solution, I'm going to have to go back to the company and approach them on SQL express route...

  10. #10

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    Quote Originally Posted by Roberto View Post
    I don't know what's odd about it - shameful certainly but not odd. Far too much educational software is made by people who appear to have never actually used a computer before in their lives. Or at best, have what the charitable person might call "unconventional views" about how to build applications.
    Odd because MS Access is seriously limiting in terms of concurrent connections. You'd of thought it's common knowledge from a developer point of view.

  11. Thanks to Michael from:

    mac_shinobi (5th February 2013)

  12. #11

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,841
    Thank Post
    25
    Thanked 91 Times in 71 Posts
    Rep Power
    51
    Can't help sorry, we only had a maximum of 15 kids and it was stil pants

  13. Thanks to Simcfc73 from:

    Willott (5th February 2013)

  14. #12

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    Quote Originally Posted by Simcfc73 View Post
    Can't help sorry, we only had a maximum of 15 kids and it was stil pants
    Firework lighting time...

  15. #13

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,134
    Thank Post
    598
    Thanked 1,062 Times in 817 Posts
    Blog Entries
    15
    Rep Power
    473
    How did you guys manage to get the MDB to run from a server? Just got Food in Focus 2, which is just a standard MSI (extracted from EXE) and absolutely no documentation. The only things the package changes is puts those files in; therefore it'll run from a shared drive in theory, yet more than one connection makes it fail.

  16. #14

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    To be honest, I can't remember... think I may have run install on server (or install on client, pointing to server drive). It's basically an exe with a mdb, so the whole program folder can sit on a share.

  17. #15

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,854
    Thank Post
    3,370
    Thanked 1,065 Times in 984 Posts
    Rep Power
    367
    Something to try

    MDB and program installed on the same os as what the clients will use ( will refer to this machine as the server even though it has a client os )

    On the server pc launch and set options in ms access and in control panel ref limiting connections etc

    Try from a number of clients and see if its the same ?

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [Fog] PXE Boot Menu Password Causes Failure to connect to DB
    By mpmackenna in forum O/S Deployment
    Replies: 1
    Last Post: 14th January 2010, 01:12 AM
  2. College student on work experience - access to school DB? Yay or nay?
    By Ben_Stanton in forum How do you do....it?
    Replies: 8
    Last Post: 2nd April 2009, 02:58 PM
  3. Web based questionnaire to Access/SQL express dB
    By joe90bass in forum How do you do....it?
    Replies: 4
    Last Post: 23rd June 2008, 02:46 PM
  4. Which access point am i connected to software
    By Southwell in forum Hardware
    Replies: 7
    Last Post: 8th February 2008, 09:05 AM
  5. Access DB to MySQL
    By Gatt in forum Web Development
    Replies: 3
    Last Post: 29th November 2006, 10:32 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •