Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.
peterrobertson
0
Newbie Poster
Recommended Answers
Jump to Postno. 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
Jump to Postno. 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
All 8 Replies
jbennet
1,618
Most Valuable Poster
Team Colleague
Featured Poster
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
peterrobertson
0
Newbie Poster
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?
jbennet
1,618
Most Valuable Poster
Team Colleague
Featured Poster
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
peterrobertson
0
Newbie Poster
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
jbennet
1,618
Most Valuable Poster
Team Colleague
Featured Poster
look up database technologies like ADO and ADO.NET
peterrobertson
0
Newbie Poster
Thank very much for your help.
Cheers
K7AAY
0
Newbie Poster
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 !
peterrobertson
0
Newbie Poster
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, networking, learning, and sharing knowledge.