Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Table Attribute to hidden after table created

Status
Not open for further replies.

DanScott

Programmer
Sep 13, 2002
14
US
I currently have a procedure in place that will delete a table if it exists and use the docmd.transferdatabase to import all new data on a weekly basis. This all seems to work fine, the only thing I would like to do is, after importing the table, set the attibute to hidden using VBA. I cannot imagine this task being difficult and probably look foolish asking, but How do I do it. I don't use the createtabledef to create it so I cannot set the attibute with the way I create the table, or can I. Any help is greatly appreciated.
 

Consider using Access security to restrict user rights to tables etc by either specific user or group.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top