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.
1
Reply
AdChoices