File already in use...

fedefifi>Access is a multi user system but if users are trying to write to the same page then locks can occur. If this is what is happening then you can catch the error, and for example inform the user to try again later!

some references which may help
http://www.devguru.com/technologies/ado/quickref/error.html
http://www.devguru.com/technologies/vbscript/quickref/onerror.html

fedefifi>You should also concider which lock types you are using. For example, if th edata is only to be read and NOT altered then you should lock for read only. This will allow other users to read the same data.
You should also FREE th econnection as soon as possible, dont keep it open until the user decides to commit his changes (he may have gone to lunch).
It is also possible to program you code so that the read is attempted a number of times IF an error occurs. Only when this number is exceded do you inform the user.