User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 374,166 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,307 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 1712 | Replies: 8 | Solved
Reply
Join Date: Jan 2008
Posts: 5
Reputation: peterrobertson is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
peterrobertson peterrobertson is offline Offline
Newbie Poster

Help access switchboard

  #1  
Jan 7th, 2008
Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation: jbennet is a jewel in the rough jbennet is a jewel in the rough jbennet is a jewel in the rough jbennet is a jewel in the rough 
Rep Power: 30
Solved Threads: 263
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Microsoft Fanboy

Re: access switchboard

  #2  
Jan 7th, 2008
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
Last edited by jbennet : Jan 7th, 2008 at 4:42 pm.
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
Reply With Quote  
Join Date: Jan 2008
Posts: 5
Reputation: peterrobertson is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
peterrobertson peterrobertson is offline Offline
Newbie Poster

Re: access switchboard

  #3  
Jan 7th, 2008
Originally Posted by jbennet View Post
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?
Reply With Quote  
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation: jbennet is a jewel in the rough jbennet is a jewel in the rough jbennet is a jewel in the rough jbennet is a jewel in the rough 
Rep Power: 30
Solved Threads: 263
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Microsoft Fanboy

Re: access switchboard

  #4  
Jan 7th, 2008
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
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
Reply With Quote  
Join Date: Jan 2008
Posts: 5
Reputation: peterrobertson is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
peterrobertson peterrobertson is offline Offline
Newbie Poster

Re: access switchboard

  #5  
Jan 7th, 2008
Originally Posted by jbennet View Post
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
Reply With Quote  
Join Date: Apr 2005
Location: Old Hampshire, Old England (LOL)
Posts: 11,937
Reputation: jbennet is a jewel in the rough jbennet is a jewel in the rough jbennet is a jewel in the rough jbennet is a jewel in the rough 
Rep Power: 30
Solved Threads: 263
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Microsoft Fanboy

Re: access switchboard

  #6  
Jan 8th, 2008
look up database technologies like ADO and ADO.NET
TRY MY SUGGESTIONS AT YOUR OWN RISK!
james.bennet1@ntlworld.com
Reply With Quote  
Join Date: Jan 2008
Posts: 5
Reputation: peterrobertson is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
peterrobertson peterrobertson is offline Offline
Newbie Poster

Re: access switchboard

  #7  
Jan 8th, 2008
Thank very much for your help.
Cheers
Reply With Quote  
Join Date: Jan 2008
Location: SE PDX, OR
Posts: 12
Reputation: K7AAY is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 1
K7AAY's Avatar
K7AAY K7AAY is offline Offline
Newbie Poster

Solution Re: access switchboard

  #8  
Feb 1st, 2008
Originally Posted by peterrobertson View Post
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 !
Last edited by K7AAY : Feb 1st, 2008 at 1:06 pm. Reason: Grammar fix
Reply With Quote  
Join Date: Jan 2008
Posts: 5
Reputation: peterrobertson is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
peterrobertson peterrobertson is offline Offline
Newbie Poster

Re: access switchboard

  #9  
Feb 1st, 2008
Thanks for the info re switchboard.
Peter
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MS Access and FileMaker Pro Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 4:11 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC