Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.

Recommended Answers

All 8 Replies

no. Access forms need access to be running to run.

However, you could always use a programming language to write standalone applications which grab data from an access database

no. Access forms need access to be running to run.

However, you could always use a programming language to write standalone applications which grab data from an access database

Something to open the main switch board? and allow that to then open forms as normal?

no. sorry

you can only use your acces-created forms in access but you can use externally programmed forms to read data from an access database

no. sorry

you can only use your acces-created forms in access but you can use externally programmed forms to read data from an access database

Thanks for the reply, where would I get information on how to make an externally programmed form?
Cheers

look up database technologies like ADO and ADO.NET

Thank very much for your help.
Cheers

Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.

Sorta kinda.

If you take an Access database with a Switchboard menu
and do Tools | Database Utilities | Make an MDE File

Then, right-click on the title bar of the database object window and select Properties
Make sure Display Form/Page is set to Switchboard
and then set all these tick boxes off:
Allow Full Menus
Display Database Window
Allow Built-In Toolbars
Allow Toolbar/Menu Choices
Then, you've locked up the database and users can't do anything not in the Switchboard.

Neither can you, so make sure to do this only with a copy of the MDB file you convert to MDE. If you need to make changes in the Switchboard or do things which aren't in the Switchboard, you will need that MDB !

Thanks for the info re switchboard.
Peter

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.