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 ...
26th March 2012, 09:31 PM #1
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.
IDG Tech News
5th February 2013, 12:33 PM #2
@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.
5th February 2013, 12:36 PM #3
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.
5th February 2013, 12:38 PM #4
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)
5th February 2013, 12:38 PM #5
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.
5th February 2013, 12:39 PM #6
Have done that - they have previously blamed storage back end... I've now tried 3 different storage backends...
Originally Posted by Michael
5th February 2013, 12:42 PM #7
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)?
Originally Posted by Willott
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.
5th February 2013, 12:43 PM #8
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.
5th February 2013, 12:44 PM #9
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...
5th February 2013, 12:45 PM #10
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.
Originally Posted by Roberto
Thanks to Michael from:
mac_shinobi (5th February 2013)
5th February 2013, 03:46 PM #11
Can't help sorry, we only had a maximum of 15 kids and it was stil pants
Thanks to Simcfc73 from:
Willott (5th February 2013)
5th February 2013, 05:30 PM #12
Firework lighting time...
Originally Posted by Simcfc73
2nd July 2013, 02:34 PM #13
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.
2nd July 2013, 02:35 PM #14
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.
2nd July 2013, 03:04 PM #15
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 ?
By mpmackenna in forum O/S Deployment
Last Post: 14th January 2010, 02:12 AM
By Ben_Stanton in forum How do you do....it?
Last Post: 2nd April 2009, 03:58 PM
By joe90bass in forum How do you do....it?
Last Post: 23rd June 2008, 03:46 PM
By Southwell in forum Hardware
Last Post: 8th February 2008, 10:05 AM
By Gatt in forum Web Development
Last Post: 29th November 2006, 11:32 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)