Not allowing users to view tables/queries/macros etc.

[racerboy]

I looked in the A97 help index on how to set it up so that when a user opens the db, all they see is my Switchboard.

This is what it said:
You can set the StartupShowDBWindow property to False to hide the Database window so the user can't see the tables, queries, macros, and modules within your database.


But it didn't tell me how to do this?

Do security permissions have to be set first? When I use the examples that come with A97 (like the Northwind db) it opens the db, but then minimizes the dialog window right away. (I already tried clicking off the Display Database Window in the Startup box, but the dialog box still comes up when I open the db).

Thanks for any help...
f.

 

[racerboy]

OK, now it seems to work. It seems that all I had to do was get completely out of the db after unchecking the Display Database Window.

I would still be interested in knowing how I would go about setting the StartupShowDBWindow property to false.

Thanks again! )

f.

 

[Dustman]

Hey, I don't know if its the same in A97, but in A2000, there is a "Startup..." menu secection uncer the "Tools" menu. The "Display Database Window" check box is what you are wanting.

-Dustin

 

[racerboy]

Hey Dustin,
Yeah, there is a Startup menu in A97 as well and there is a Switchboard Manager. I'm really new to Access (but having a lot of fun with it) so I apologize if some of my questions seem stupid! )

-Frank

 

[Dustman]

Hey, no prob man. The best way to learn is to ask questions. I'm pretty new to Access myself so it makes me happy to help sombody else.

-Dustin