Concurrent User

[ponsaran]

Is it possible to work concurrent users  in the same project file(EAP) which is located in any common node(server)

Expecting the answer asap

Thanks
Saravanan

[«Midnight»]

I believe so, although you might experience slight glitches if Jet does not handle your transactoins perfectly.

As I remember it EA used to open EAP files exclusively, but no longer does so. I have often opened an EAP file from the automation interface, as well as creating a database connection to the same file - which was not possible with the old EA locking mechanism - and had the file open on my desktop. I sometimes have to refresh diagrams or the entire project with the desktop session (I use it primarily to view what's happening in the other sessions) but things have worked out pretty well.

MS has a knowledge base article - with a specific instance for each version of Access - warning that the product is not guaranteed to work in a shared environment across a network. You can find the article with a bit of searching (I don't have the URL since MS last reorganized their knowledge base); it is probably worth reading to make sure you know the risks to watch for.

Remember to back up your work often!

[Eve]

The desktop and professional versions of EA are intended to open EAP files exclusively, while the corporate edition allows for concurrent use.