V
Vince
We are using a product called PES. It is Visual Basic over
Access and is manufactured by EDS. Since the database is
open to us we had created some custom reports and had bulk
loaded it. All was well and we have been using it in
production for several weeks.
This Monday, a user contacted me reporting that they could
no longer use the reports since they didn't have the
password. I checked and access to the database is now
password protected. I checked Microsoft and in their tech
bulletins they have published two related articles.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;243895&Product=acc2000
http://support.microsoft.com/default.aspx?scid=kb;en-
us;321905&Product=acc2000
However, one article dosen't offer any resolution, aside
from "don't do this" and the other offers a solution which
simply does not work. The help desk for the manufacturer
won't support us since "we directly accessed the Access
database". Basically it looks like a corruption problem.
There is a repair tool in the application, but it states
that all users need to be off before using it and of
course all users are off the application. We've re-booted
the server in an effort to clear the lock but to no avail.
Any suggestions you may have would be greatly appreciated.
Access and is manufactured by EDS. Since the database is
open to us we had created some custom reports and had bulk
loaded it. All was well and we have been using it in
production for several weeks.
This Monday, a user contacted me reporting that they could
no longer use the reports since they didn't have the
password. I checked and access to the database is now
password protected. I checked Microsoft and in their tech
bulletins they have published two related articles.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;243895&Product=acc2000
http://support.microsoft.com/default.aspx?scid=kb;en-
us;321905&Product=acc2000
However, one article dosen't offer any resolution, aside
from "don't do this" and the other offers a solution which
simply does not work. The help desk for the manufacturer
won't support us since "we directly accessed the Access
database". Basically it looks like a corruption problem.
There is a repair tool in the application, but it states
that all users need to be off before using it and of
course all users are off the application. We've re-booted
the server in an effort to clear the lock but to no avail.
Any suggestions you may have would be greatly appreciated.