URGENT !!! Using 2 executables to access the same ".mdb" file
Posted on 2000-05-11
The situation is like this - I have written a server that keep track of some information (coming from the I/O port). This information is stored under an ".mdb" file - say "ABC.mdb"
Everything is fine until I want another executable to access "ABC.mdb" for informatin retrieval.
There will be an error message prompting "Cannot be updated : ABC.mdb is being locked by another program".
I guess this is because I am already using the server program to access the ".mdb" file and it will update the database whenever new information arrives.
I need your help and advices!!!!!
So how can I overcome this "locking" problem and fullfil the goal of constantly updating the file, while allowing information retrival at the "same time".
Any suggestions and comments are welcome. Your help is much appreciated.
As my customer is small business - so it would not be possible to provide them with a server solution (in business point of view).