Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9
This is the forum to discuss the Wrox book Expert Access 2007 Programming by Rob Cooper, Michael Tucker; ISBN: 9780470174029
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 4th, 2008, 10:17 PM
Authorized User
 
Join Date: Oct 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dashboard example

This is an excellent Access Book !!!. I´ve been trying to make the dashboards components avaiable to different users using a table of options, so I decided to go to chapter 12, but althought it says how to save different options (by a table o in the registry), I can understand how can I manage to applied the dashboard example with different users , when two of them can choose the same dashboard...

Anyway great book, well written !!!, with a los of useful examples

Reply With Quote
  #2 (permalink)  
Old January 5th, 2008, 02:41 PM
Wrox Author
 
Join Date: May 2007
Location: , Washington, .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Thanks for the question. I'm glad you are finding the book helpful!

If the database is split, you can use the table approach for options and store "user" options in a table in the front-end database. This should allow for multiple users to have their own choices for the components as each user will have their own table.

You could extend this design further and create an options table in the back-end database where option values stored in this table would be similar to "system" options.

An alternative design would be to make the options table aware of the user who is using the system. This can be done with another column in the options table for the user name, or perhaps with a lookup into a user table to help keep the options table normalized. If you are using a custom security scheme, this might be a viable approach.

Hope this helps! Thanks again.

Rob Cooper
Lead Software Design Engineer in Test
Microsoft Access Team

co-author: Access 2007 VBA Programmer's Reference
co-author: Expert Access 2007 Programming

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at microsoft.com/info/cpyright.htm.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with login logic and Dashboard alanphil BOOK: Professional CodeIgniter ISBN: 978-0-470-28245-8 18 August 13th, 2009 05:04 AM
Dashboard Example with different users mruschetti BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 7 February 9th, 2008 05:18 PM
Dashboard reporting tool luxx Excel VBA 0 January 2nd, 2004 12:26 PM



All times are GMT -4. The time now is 08:24 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.