Increase maximum number of connections

[DrkJrny]

I'm working on a project where I'm creating Data Loggers through KepServerEx5. Basically I'm using Kepware to connect to our company's PLC programming through a DSN to log station cycle times and then dumps the information into an Access table (idb file). I hit a point where I could no longer make additional connection to the Access table and received an error that the table did not exist when though in reality it did. In order to add any additional Data Loggers I have to disable any previously entered data loggers. It appears that I've hit some sort of threshold in regards to how many data loggers can connect to this particular table. Is there any setting that I can change to increase that threshold? I've looked and I'm coming up empty. The version of Access that is being used is 2007. Any help is greatly appreciated.

[orange]

This info re Connections might offer some insight.

[pbaldy]

How many are we talking about? If 255, that is the limit of concurrent users that can connect to a database.

[DrkJrny]

Thank you Orange

[DrkJrny]

I guess I need to figure out how it is determining the number of users. I don't have that many data loggers, but there are several bits of information that is being pulled in each one. That may be throwing me over the top. Thanks for the insight. Gives me something to work with.

[isladogs]

I've used the form that orange suggested and it works well - very useful for developers to track issues
If you test it with your database you will find certain actions use more than one connection

Add a datalogger and determine its impact. Add another and repeat
Remove each in turn and check whether the connections used are all freed.
If not look for causes e.g recordsets not closed

Once you have done several tests it should be possible to set a limit to the number of dataloggers that you allow at a time

[ssanfu]

Don't know what your code looks like, but you should read http://accessblog.net/2005/12/be-car...currentdb.html
Look at the comment by Alex Dybenko re DBEngine(0)(0)

[beilstwh]

If you are using more then 255 connections you are using the wrong tool. Access just can't scale up like that. I would load up the free version of sql server, use the built in wizard in access to move all data files into sql server. Sql server doesn't have a connection maximum that you will (probably) ever hit.