Database Connections

[PeteCan]

With Access is there:

i) A limit to the number of database connections you can have at one time

ii) How can you kill off these connections?

 

[SiJP]

I beleive the limit is 255 (I could be wrong). IMHO you should consider upsizing to SQL if more than 50 users are trying to connect. Although other access DBA's have sucessfully had more users that this, there are performance issues that need to be looked at overall.

To Kill a connection? The user closing the DB should be enough.. (check the LDB)

If you want to manage this remotely (i.e. close a user remotely) then you'd need to create a custom admin module.

e.g. Table with the username and a closedown flag.

Set the flag to 1 to close it down for that user.

Have a form that on a timer checks this table and invokes docmd.quit if that user has the flag set...

HTH's?

------------------------
Hit any User to continue