Access who is connected to db

Some are static between sessions and stored in the local table named tblSettings. Data that is recorded in tblConnectedUsers This is a user selectable option.

For example: you should not have two instances of "WhoIsConnected. I did not have a database go corrupt during the time I was monitoring it I hate to "Release" an app that has not been completely "Tested" Also, if you "track this topic" under the Options button with email notification, you will be notified of updates and other postings on this thread topic regarding this utility.

Last edited: Mar 23, Similar threads Z. Most secure way of connecting to SQL Server. Replies 17 Views Replies 13 Views Sep 29, Minty. Viewed 3k times. Tony Toews 7, 1 1 gold badge 20 20 silver badges 26 26 bronze badges.

Add a comment. Active Oldest Votes. Tim Tim 5, 3 3 gold badges 30 30 silver badges 41 41 bronze badges. Thanks for this advice, I've changed the connectionstring of my program to open the database in exclusive mode but there are no changes. If I open the db with my program in exclusive mode I can still useable even access from any computer without a error that the db is already open.

Ok: There's no reason why access will not be fine with multiple users - however its performance over a network can be a poor and there are better alternatives.

If its open there will be a. Tim has the first solution right in terms of looking at Exclusive Mode I'd probably also suggest putting your own "lock" file in place rather than relying on any mechanisms in access And if the only reason you want to restrict connections to the file is concerns with concurrent access then you seriously need to review whether you are using the right tools.

Murph Murph 9, 2 2 gold badges 24 24 silver badges 41 41 bronze badges. The rest of the database options for the read and write connections will be merged from the main mysql array.

So, we only need to place items in the read and write arrays if we wish to override the values in the main array. So, in this case, The database credentials, prefix, character set, and all other options in the main mysql array will be shared across both connections.

Once you have configured your database connection, you may run queries using the DB class. The first parameter of this function can optionally be used to specify a particular database group from your config file, or you can even submit connection values for a database that is not specified in your config file.

For information on each of these values please see the configuration page. To override default config values when connecting with a DSN string, add the config variables as a query string.