Existing Access Database Troubleshooting
I am new to access database and inherited an access application and
all users who were previously able to use this access file
simulataneously are now locked out exclusively . Some have not been
able to get on at all. Obviously, this is the problem, and as far as I
know, no changes have been made to access backend or front end. I have
no historical data as to whether or not the access db was secured
previously,..)
This access db is on a network share, and i have no knowledge if it's
verifying against a .mdw file on the network or on a computer
somewhere on a network. How would one determine where the access
database looks to to verify if a users are in a certain workgroup?
I've gone through most of the menu options on the access database and
couldn't find one that would show me where it references for it's
workgroup information model it uses.
If I were to recreate a new workgroup information file with this
accesss dataabase, should I be concerned about overriding any other
configuration that access may reference from a previously created file
(if one existed, and if somehow, it's referencing an existing file..?
or would this corrupt the access database.. ?)
I have downloaded the FAQ Security Access and reading through it to
understand what I need to do to recreate a workgroup file. However, I
do not know what to anticipate breaking if I recreated one, ... and
just wanted to see if any thoughts could be shared on this.
Any guidance as to how to troubleshoot an application on a network
share would be appreciated.