You are here: MS Access Products > Dashboard Builder > Product Support > FAQ
Contact Sales 888.967.6483
Dashboard BuilderTM for Microsoft® AccessTM
Frequently Asked Questions
Topics
|
Q: Can I use Dashboard BuilderTM in products I sell?
A: Absolutely. Please purchase the Dashboard Builder Redistribution license, which grants you unlimited license to package UI Builder within your own applications. You must maintain all OpenGate Software copyright notices, however. Contact us for pricing at orders@opengatesw.net
Configuring Dashboard Builder
A. Yes. Refer to the UI Builder tip "How to deploy user-level menus using a single back-end database."
SQL Where Statements
Q. Where can I learn about creating SQL statements?
A. OpenGate Software recommends you begin with a free online tutorials, a few are listed below:http://www.w3schools.com/sql/sql_where.asp
Q. Why does Dashboard Builder change my quotation marks and wildcard characters after I enter them?
A. Dashboard Builder changes " to ' and * to % to be compatible with the data access components used to collect your data. This is a normal part of Dashboard Builder's operation and should not be cause for concern.
Q. Can I create metrics that join multiple tables?
A. You will need to first create and save a query that joins the tables you need, then create a metric that uses that query as the Data Source.
Deploying as a runtime file
Q. Can I deploy Dashboard Builder to users with a runtime version of Access?
A. Yes, Dashboard Builder is fully compatible with the as a runtime database, which can help cut down on the number of Access licenses you need.
Deploying with Microsoft® SQL Server TM or MySQL® Server
Q. Can I deploy Dashboard Builder with an Access database linked to Microsoft SQL Server or MySQL?
A. Yes. Dashboard Builder is compatible with linked tables connected to Microsoft SQL Server or MySQL databases. Please note that Dashboard Builder is not compatible with ADP format databases, which interoperate with Microsoft SQL Server databases in a vastly different manner than linked tables.
Troubleshooting
Q. I am using a query with a dashboard metric, and no data is returned.
A. If you are using a "Like" SQL statement that uses the wildcard character *, please change your SQL statement in the query you are referencing to the following: "WHERE [YOURFIELD] LIKE '*SOMETHING' OR [YOURFIELD] LIKE '%SOMETHING'" You must add both the * and % forms of the Where clause for the query to behave as expected both when you open it directly, and when it is used by Dashboard Builder.
 | Copyright © 2010 OpenGate Software Inc. All Rights Reserved. |  |