DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   MS Access and FileMaker Pro (http://www.daniweb.com/forums/forum128.html)
-   -   access switchboard (http://www.daniweb.com/forums/thread103801.html)

peterrobertson Jan 7th, 2008 4:22 am
access switchboard
 
Is there a way to open the main access switchboard in windows without showing the access program? as a usable Data Base.

jbennet Jan 7th, 2008 4:42 pm
Re: access switchboard
 
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 Jan 7th, 2008 4:58 pm
Re: access switchboard
 
Quote:

Originally Posted by jbennet (Post 506126)
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 Jan 7th, 2008 6:58 pm
Re: access switchboard
 
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 Jan 7th, 2008 7:59 pm
Re: access switchboard
 
Quote:

Originally Posted by jbennet (Post 506195)
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 Jan 8th, 2008 2:09 pm
Re: access switchboard
 
look up database technologies like ADO and ADO.NET

peterrobertson Jan 8th, 2008 4:23 pm
Re: access switchboard
 
Thank very much for your help.
Cheers

K7AAY Feb 1st, 2008 1:05 pm
Re: access switchboard
 
Quote:

Originally Posted by peterrobertson (Post 505684)
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 Feb 1st, 2008 4:57 pm
Re: access switchboard
 
Thanks for the info re switchboard.
Peter


All times are GMT -4. The time now is 3:56 am.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC