invisible table with code (Access 2000)

Topic

New Reply

Can i make a ttable invisible through a code ? Say in the OnOpen event of a form? I can do it by ticking off the options, but i want to know#how can i do it
with a code

Reply | Quote

Replies

What are you trying to accomplish and why do you want to do it from a form? Do you want to set the hidden property of the table to true or turn of the option setting to show hidden objects? If you provide more information, someone should be able to help.

Reply | Quote

Thank you for your reply.I want to set the hidden properrty of the tables to true.The point is that my programme is used on other
computers and therefore i have not the possibiliuty to use the option show hidden objects,which is the easiest way.
Therefore i have to do it by code and on opening the database to have my tables hidden.
regards

Reply | Quote

Sorry, but I still don’t quite understand. Unless you use Access security on your application, there will be nothing to stop anyone on a machine with Access installed from unhiding those tables again. Are you trying to hide the tables themselves or the database window?

Reply | Quote

u can hid a table by that code in the on open event to the form .
CurrentDb.TableDefs(“table1”).Attributes = dbHiddenObject
change table1 to ur table name.
Ashraf

Reply | Quote

Doing it that way might be dangerous, since you are overwriting any existing attributes. A safer way would be like this:

With CurrentDb.TableDefs(“table1”)
.Attributes = .Attributes Or dbHiddenObject
End With

Reply | Quote

That is exactly what i wanted. Superb !!!!

Reply | Quote

That is exactly what i wanted. Superb !!!!

Reply | Quote

Doing it that way might be dangerous, since you are overwriting any existing attributes. A safer way would be like this:

With CurrentDb.TableDefs(“table1”)
.Attributes = .Attributes Or dbHiddenObject
End With

Reply | Quote

u can hid a table by that code in the on open event to the form .
CurrentDb.TableDefs(“table1”).Attributes = dbHiddenObject
change table1 to ur table name.
Ashraf

Reply | Quote

Sorry, but I still don’t quite understand. Unless you use Access security on your application, there will be nothing to stop anyone on a machine with Access installed from unhiding those tables again. Are you trying to hide the tables themselves or the database window?

Reply | Quote

Thank you for your reply.I want to set the hidden properrty of the tables to true.The point is that my programme is used on other
computers and therefore i have not the possibiliuty to use the option show hidden objects,which is the easiest way.
Therefore i have to do it by code and on opening the database to have my tables hidden.
regards

Reply | Quote

What are you trying to accomplish and why do you want to do it from a form? Do you want to set the hidden property of the table to true or turn of the option setting to show hidden objects? If you provide more information, someone should be able to help.

Reply | Quote