I notice that it is now possible to connect to a database via the embedded server and simultaneously connect via other embedded processes to the same database file. This was not possible in previous version – the second process would be locked out.

Can someone lead me to an explanation of how these multiple connections are managed? Which embedded server will coordinate updates and modifications to the database?

It appears that updates from one process are visible to the other(s) but I’m not sure how the second would know if a transaction is being managedin the first – is there a lock file being written to somewhere that I can’t find?

(WIN32) V2.5

Regards

Alan McDonald