Access DB

sheridanbman wrote:
> Im trying to query a database that is opened by a user that is inputting data
> into it. It will not allow me to query it while its opened. I tried splitting
> the db and this didnt seem to help. Any ideas??????
>


What do you mean by 'splitting' the database?

You can NOT query an Access database that is open by a user. This is
one of the many reasons that the desktop Access database management
system is NOT recommended in a server role.

Many people do use Access. If you understand and work around its
limitations it can do quite a bit.

For this case, the usual work around is to NOT let users directly open
the copy of the database on the server. The users modify the data file
from some other location. When they are done, a copy of the updated
data file is moved to the server to replace the file that is there.