Using Usys before table name

[Guest]

Some one advised me that if a type usys before the table name, then this will
block any users from seeing or altering the table. The problem seems that
when you go to open the Main Form (Menu driven), the system says that it
cannot find the table. Any clues?
With thanks

 

[Terry Kreft]

It will only block casual users, if they go to tools/options/view and check
system objects they'll be able to see them.

 

[Guest]

Thanks Terry, I understand that, but, why can't you open a Form when you add
this to the table. Is it because the table name has actually changed and you
would need to point the control to the renamed table?

Thanks again

 

[Nick Coe \(UK\)]

Thst is very probably what it is. If you had the
form/control bound to the old table name then changed that
table name (regardless of putting Usys in front) then the
form/control can no longer find the table.

--
Nick Coe (UK)
http://www.alphacos.co.uk/




In Roger Bell typed:

 

[Terry Kreft]

Yes, if you ...
created the table,
built the form,
renamed the table,

.... then you need to point the form at the newly named table.