The Usys prefix simply allows a convenient method of hiding objects.
However, if you have the view system objects option enabled (Tools | Options
---> View Tab), you will see them anyways.
Can it be deleted? or how this file being created.
Only if you don't need the query, form or report in question. They are being
created because someone thought they could be sneaky and hide objects from
others by using the Usys prefix. It's really not an effective method, as you
have quickly learned. Consider renaming these by removing the Usys prefix,
but you may have to correct other dependencies if you do this.
You can set any object to be hidden - USys is probably as much a documentation
tool to identify "user system" tables as it is a security technique. All of
the trivial ways to hide objects have equally trivial ways to undo.
To PREVENT accidental deletion or renaming, implement Access security. I know,
I know - it can be cracked by a determined person knowledgable about Access -
but just as a $80 bicycle lock can make it irksome for a determined thief and
deter casual ones, so can security make your application safer. See the
Microsoft Access 2000 Security FAQ:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
