Hello ppl:
I am facing a problem that I ahve never experienced before with the
secured database. I created an MS Access 2000 application (.mdb) using
MS Access 2002 and secured it using exactly the procedure described in
the Access Security FAQ and as I have been doing since the time I
have started using Access.
So let the access application be xxx.mdb. After completing the whole
development for xxx.mdb, i secured it using the procedure defined in
the FAQ and created the Workgroup information file for it, say
xxx_WIF.mdw. I tested it for my satisfaction and everything was
working exactly the way it is supposed to.
Now the problem I am facing is, that when the project went into QA
phase, the QA team observed that on the machines that the application
was installed for testing, the users were able to open and use the
application without using its defined workgroup information file
(xxx_WIF.mdw) and the default WIF of windows worked for them to open
the database.
Then i again tested on my beta machine and 4 other machines and quite
surprisingly it works fine on 3 machines i.e. I am not able to acess
the application without using xxx_WIF.mdw but on other two machines,
the user is able to open it using the default windows WIF
(system.mdw). (All machines use MS Access 2002 with SP3 installed)
I tried many methods to observe the reason for this behavouri but was
unsuccesfull and now have to turn to the community for SOS. Any inputs
from the community will be highly appreciated and is needed urgently
as the application is scheduled to be deployed into a couple of days.
Thanks,
Nitin
Peace :)