Usys prefix

K

Kyle

What are those Usys prefix in the file name within forms, queries or reports?
Can it be deleted? or how this file being created.

Thanks.
 
T

Tom Wickerath

Hi Kyle,

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.
Click to expand...

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.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
K

Kyle

If it is not an effective method to hide the objects, what is other method to
hide this objects to prevent accidently delete or rename.

Thanks.
 
J

John W. Vinson

If it is not an effective method to hide the objects, what is other method to
hide this objects to prevent accidently delete or rename.
Click to expand...

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:

http://support.microsoft.com/kb/207793/en-us

and perhaps review Lynn Trapp's Security discussion at
http://www.ltcomputerdesigns.com/Security.htm
 
Top