G
George
I'm having a bit of a problem here, nothing serious but very annoying.
We have an access 2000 db as a back end that is created by macro to
take required data out of one database and put it in another. This is
then uploaded to a webserver for people to get quote info via a web
page. It works well but when we want to upload the new db each week,
if there is a lockfile on the server then we have to wait and wait up
to 20 minutes until the lockfile disappears or we can delete it and
then upload the new db. It's an NT server using an odbc connection. Is
there a way to get rid of this lockfile or at least have the lockfile
delete itself after a much shorter time? Is it even possible to open
the db without the lockfile? We would like to "kick" people out of the
db for about 5 minutes to do the update.
TIA for any advice
We have an access 2000 db as a back end that is created by macro to
take required data out of one database and put it in another. This is
then uploaded to a webserver for people to get quote info via a web
page. It works well but when we want to upload the new db each week,
if there is a lockfile on the server then we have to wait and wait up
to 20 minutes until the lockfile disappears or we can delete it and
then upload the new db. It's an NT server using an odbc connection. Is
there a way to get rid of this lockfile or at least have the lockfile
delete itself after a much shorter time? Is it even possible to open
the db without the lockfile? We would like to "kick" people out of the
db for about 5 minutes to do the update.
TIA for any advice