Originally posted by Ramesh Israni: In the local DB mode, should I worry about the user running two instances of the application.
Hum... this one is sort of hard to answer. But, I would say yes. But, I think you can impose this kind of restriction (only one window of the application client can be opened at a time), but I don't know if you would loose points because of that.
you should have a look at the "Locking" chapter of your assignment. There may be some clue about your question. In my assignement, there is the following sentence :
You may assume that at any moment, at most one program is accessing the database file; therefore your locking system only needs to be concerned with multiple concurrent clients of your server.
For me, it means that there will be only one software accessing the database file at any moment. However, this software could be a GUI client, or a server with several clients connected (concurrency issues in that case).