1

For application startup I had to open a table as part of some DAO.recordSet code.

 DoCmd.OpenTable "User", acNormal, acReadOnly

On running user tests, I want to distribute the desktop application as a run-time file (.accdr) but the access table is visible. All I can find is how to hide navigation area objects.

I, of course, do not want the table visible to users, so my question is how do I hide it?

Marcus Mackaku
  • 23
  • 5

1 Answers1

1

This article at TechRepublic offers two approaches.

One is to set the table as hidden.

Right-click the object in the Database window.

Choose Properties.

Click the Hidden option.

The other is to rename the table.

Another way to hide a table is to add the prefix Usys to the table's name.

Both aren't really secure, as the object is still accessible, but it's not visible at least.

Community
  • 1
CaM
  • 2,193
  • 12
  • 21