# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=59 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 60 --- ## [Creating a connection to and Access Database](https://forum.inductiveautomation.com/t/creating-a-connection-to-and-access-database/80)
**Author:** [@bhastie1](https://forum.inductiveautomation.com/u/bhastie1)\ **Replies:** 1\ **Last updated:** [April 14, 2006, 7:02am UTC](https://forum.inductiveautomation.com/t/creating-a-connection-to-and-access-database/80 "2006-04-14T07:02:35Z")
I am trying to create a connection to an Access database and having no luck. Can you provide a little guidance and perhaps an example. Thanks. --- ## [Your favorite SQL database to work with for plant systems](https://forum.inductiveautomation.com/t/your-favorite-sql-database-to-work-with-for-plant-systems/78)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [April 8, 2006, 1:22am UTC](https://forum.inductiveautomation.com/t/your-favorite-sql-database-to-work-with-for-plant-systems/78 "2006-04-08T01:22:54Z")
What is your favorite SQL database to work with for plant systems? Oracle Microsoft SQL Server MySQL PostgreSQL IBM DB/2 Microsoft Access (please say you're joking...) Other 0voters Show results What is your f… --- ## [Hardware versus software VPNs](https://forum.inductiveautomation.com/t/hardware-versus-software-vpns/74)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 5, 2006, 11:29pm UTC](https://forum.inductiveautomation.com/t/hardware-versus-software-vpns/74 "2006-04-05T23:29:36Z")
I've configured my Windows 2003 server as a VPN server. How does this compare to using hardware VPNs? Do you have recommendations for brands of hardware VPNs to use. I notice that most consumer vendors have these devices… --- ## [Microsoft Access support](https://forum.inductiveautomation.com/t/microsoft-access-support/65)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [April 5, 2006, 7:41pm UTC](https://forum.inductiveautomation.com/t/microsoft-access-support/65 "2006-04-05T19:41:51Z")
I can't find a JDBC driver for Microsoft Access. Can you include support in FactoryPMI? --- ## [Align Centers](https://forum.inductiveautomation.com/t/align-centers/66)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [April 5, 2006, 7:28pm UTC](https://forum.inductiveautomation.com/t/align-centers/66 "2006-04-05T19:28:19Z")
This was a request from one of our integrators. They wanted alignment buttons that would align objects centers with respect to each other. "Align Centers Vertical" and "Align Centers Horizontal" --- ## [Document Viewer upgrade](https://forum.inductiveautomation.com/t/document-viewer-upgrade/68)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [April 5, 2006, 7:27pm UTC](https://forum.inductiveautomation.com/t/document-viewer-upgrade/68 "2006-04-05T19:27:52Z")
I'm making a context sensitive help system. When the user hits "F1" the system should open an HTML formatted help window based on the current window. The problem is that the document viewer wants a URL to populate the da… --- ## [Shortcut key - Duplicate (Cntl+D)](https://forum.inductiveautomation.com/t/shortcut-key-duplicate-cntl-d/67)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [April 5, 2006, 7:10pm UTC](https://forum.inductiveautomation.com/t/shortcut-key-duplicate-cntl-d/67 "2006-04-05T19:10:32Z")
Feature from one of our integrators. Cntl+D would be the same as a Cntl+C followed by a Cntl+I, except without going to the clipboard. --- ## [Send emails from FactoryPMI](https://forum.inductiveautomation.com/t/send-emails-from-factorypmi/69)
**Author:** [@integrator\_adam72](https://forum.inductiveautomation.com/u/integrator_adam72)\ **Replies:** 1\ **Last updated:** [April 5, 2006, 7:08pm UTC](https://forum.inductiveautomation.com/t/send-emails-from-factorypmi/69 "2006-04-05T19:08:51Z")
I'd like to request the ability to send emails from within FactoryPMI clients. That way operators could send text messages or alphanumeric pages to their guys in the field. Often times their cell phone coverage is spotty… --- ## [Developer undo (Cntl+Z) feature](https://forum.inductiveautomation.com/t/developer-undo-cntl-z-feature/25)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 2\ **Last updated:** [April 5, 2006, 6:41pm UTC](https://forum.inductiveautomation.com/t/developer-undo-cntl-z-feature/25 "2006-04-05T18:41:31Z")
FactoryPMI doesn't seem to have an undo feature. Am I missing something? --- ## [MSSQL - Transaction Log grows to a very large size](https://forum.inductiveautomation.com/t/mssql-transaction-log-grows-to-a-very-large-size/58)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 1\ **Last updated:** [April 4, 2006, 6:38pm UTC](https://forum.inductiveautomation.com/t/mssql-transaction-log-grows-to-a-very-large-size/58 "2006-04-04T18:38:38Z")
Posted by: jeff\_anderson (IP Logged) Date: January 13, 2006 11:15AM Ever since I've been using FactorySQL on this particular small project my SQL Server transactions logs have been growing apparently without bound (ove… --- ## [Image property to flip image](https://forum.inductiveautomation.com/t/image-property-to-flip-image/23)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:50pm UTC](https://forum.inductiveautomation.com/t/image-property-to-flip-image/23 "2006-04-02T23:50:47Z")
Would be useful to have a checkbox for "flip horizontal" and "flip vertical" on the "image" object. I know that a single flip + rotation exist. --- ## [Line numbers in Jython editors](https://forum.inductiveautomation.com/t/line-numbers-in-jython-editors/24)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:48pm UTC](https://forum.inductiveautomation.com/t/line-numbers-in-jython-editors/24 "2006-04-02T23:48:50Z")
It would be useful to see line numbers when typing in Jython editors. The exception windows display the line number of the problem. --- ## [Loop line](https://forum.inductiveautomation.com/t/loop-line/26)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:46pm UTC](https://forum.inductiveautomation.com/t/loop-line/26 "2006-04-02T23:46:54Z")
I need to draw a loopy line to connect to my solenoid valves. I could probably do this is photoshop, but it'd be easier as a component in FactoryPMI. I noticed that the "line" component can be made into a sin wave. Cou… --- ## [Property pane gets in the way - need to shrink it down a bit](https://forum.inductiveautomation.com/t/property-pane-gets-in-the-way-need-to-shrink-it-down-a-bit/27)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:44pm UTC](https://forum.inductiveautomation.com/t/property-pane-gets-in-the-way-need-to-shrink-it-down-a-bit/27 "2006-04-02T23:44:04Z")
My monitor resolution isn't big enough for my project and the property pane and the smallest I can make it is still too big. Can it be hidden or set to size smaller? --- ## [Can't undo once I begin to move/resize objects](https://forum.inductiveautomation.com/t/cant-undo-once-i-begin-to-move-resize-objects/28)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:41pm UTC](https://forum.inductiveautomation.com/t/cant-undo-once-i-begin-to-move-resize-objects/28 "2006-04-02T23:41:33Z")
I need some way to cancel this operation (move or resize) before it finishes. --- ## [Video component](https://forum.inductiveautomation.com/t/video-component/29)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:38pm UTC](https://forum.inductiveautomation.com/t/video-component/29 "2006-04-02T23:38:19Z")
Would be cool to be able to view video feeds inside FactoryPMI --- ## [Microsoft SQL Server support](https://forum.inductiveautomation.com/t/microsoft-sql-server-support/31)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:31pm UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-support/31 "2006-04-02T23:31:07Z")
How can I use FactoryPMI with MSSQL server? --- ## [Prevent a user from closing FactoryPMI](https://forum.inductiveautomation.com/t/prevent-a-user-from-closing-factorypmi/32)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:27pm UTC](https://forum.inductiveautomation.com/t/prevent-a-user-from-closing-factorypmi/32 "2006-04-02T23:27:00Z")
I'd like to set up a few touchscreen PCs as dedicated FactoryPMI terminals. Can I make it so the user can't close the program or open other programs? --- ## [Clear input data every time a user opens up a window](https://forum.inductiveautomation.com/t/clear-input-data-every-time-a-user-opens-up-a-window/33)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:23pm UTC](https://forum.inductiveautomation.com/t/clear-input-data-every-time-a-user-opens-up-a-window/33 "2006-04-02T23:23:05Z")
I'm trying to clear out the data in input boxes every time a user opens that window. I need this data to clear for my validation to work properly. Is there an "Open Window" event so that I can use Jython to set these v… --- ## [How do you open a window by Double Clicking an object?](https://forum.inductiveautomation.com/t/how-do-you-open-a-window-by-double-clicking-an-object/36)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:19pm UTC](https://forum.inductiveautomation.com/t/how-do-you-open-a-window-by-double-clicking-an-object/36 "2006-04-02T23:19:21Z")
I figured out how to open a property window by single clicking an image link. I used the Navigation "Open" window under the mouse-\>mouseClicked event. Can I make this work by doubleclicking instead? --- ## [How do you view an updating date/time field?](https://forum.inductiveautomation.com/t/how-do-you-view-an-updating-date-time-field/39)
**Author:** [@integrator\_adam72](https://forum.inductiveautomation.com/u/integrator_adam72)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:17pm UTC](https://forum.inductiveautomation.com/t/how-do-you-view-an-updating-date-time-field/39 "2006-04-02T23:17:06Z")
How do you view an updating date/time field? I'd like to show this as a "realtime clock" on my FPMI client screens. Thanks, --- ## [Dynamically changing text labels](https://forum.inductiveautomation.com/t/dynamically-changing-text-labels/35)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 11:12pm UTC](https://forum.inductiveautomation.com/t/dynamically-changing-text-labels/35 "2006-04-02T23:12:40Z")
I'd like to have a label that describes the status of each of my conveyors. For example, when DB value "N\_convey1" = 0, the status label should read "Stopped", 1 should read "running", 2 "Auto", 3, "E-Stop". How would I … --- ## [Unable to uninstall DSxP opc server](https://forum.inductiveautomation.com/t/unable-to-uninstall-dsxp-opc-server/56)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 2:12am UTC](https://forum.inductiveautomation.com/t/unable-to-uninstall-dsxp-opc-server/56 "2006-04-02T02:12:57Z")
richie 25NOV05 - Hey, don't know if this is the right place to ask, but maybe someone can help... I installed the DSxP simulator server (took me a bit to realize that you have to set it to autostart before it'll work wit… --- ## [Printing tables](https://forum.inductiveautomation.com/t/printing-tables/55)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 2:09am UTC](https://forum.inductiveautomation.com/t/printing-tables/55 "2006-04-02T02:09:44Z")
james 14MAR06 - Is there any way to print a table in its entirety? For example, if a table has a scroll bar, can I cause even the part that isn't showing to print too? One other thing. What if I just want to save it as… --- ## [Sub folders on SQL](https://forum.inductiveautomation.com/t/sub-folders-on-sql/54)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 3\ **Last updated:** [April 2, 2006, 2:07am UTC](https://forum.inductiveautomation.com/t/sub-folders-on-sql/54 "2006-04-02T02:07:12Z")
yehuda 29MAR06 - Is it be passable to create many sub folder in the main folder on factory SQL? --- ## [Can I synch the PLCs clock to the computer?](https://forum.inductiveautomation.com/t/can-i-synch-the-plcs-clock-to-the-computer/52)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 2\ **Last updated:** [April 2, 2006, 1:59am UTC](https://forum.inductiveautomation.com/t/can-i-synch-the-plcs-clock-to-the-computer/52 "2006-04-02T01:59:02Z")
Mark 28JUN05 - My AB SLC 5/04 isn't smart enough to set its clock for Daylight Savings. Windows automatically keeps the PCs clock up to date. Is there any way to synchronize the two? --- ## [Logging values ONLY when process is running](https://forum.inductiveautomation.com/t/logging-values-only-when-process-is-running/51)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 1\ **Last updated:** [April 2, 2006, 1:56am UTC](https://forum.inductiveautomation.com/t/logging-values-only-when-process-is-running/51 "2006-04-02T01:56:05Z")
Jeff 29JUN05 - I'm successfully logging PLC readings (flow rates, current, etc) with a group in "OPC-\>DB" mode with "Insert New Record" selected. I'd only like to this data when my process is running and not "starting up… --- ## [Isn't FactorySQL just like RSSQL?](https://forum.inductiveautomation.com/t/isnt-factorysql-just-like-rssql/50)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 2\ **Last updated:** [April 2, 2006, 1:53am UTC](https://forum.inductiveautomation.com/t/isnt-factorysql-just-like-rssql/50 "2006-04-02T01:53:33Z")
BMadson 27DEC05 - I was wondering if FactorySQL is just like RSSQL or if there is there something more to it? It says on your website that it has bi-directional mode. What does that mean? --- ## [What's the ideal computer for FactoryPMI workstations?](https://forum.inductiveautomation.com/t/whats-the-ideal-computer-for-factorypmi-workstations/22)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 1, 2006, 7:16pm UTC](https://forum.inductiveautomation.com/t/whats-the-ideal-computer-for-factorypmi-workstations/22 "2006-04-01T19:16:14Z")
CPU, Memory, OS, raid arrays, what's important for a dedicated FactoryPMI terminal? I want to use industrial touch screens. Should I use entire industrial computers, or standard computers coupled with rugged, panel mou… --- ## [What's the ideal computer to run FactorySQL and FactoryPMI?](https://forum.inductiveautomation.com/t/whats-the-ideal-computer-to-run-factorysql-and-factorypmi/21)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [April 1, 2006, 7:13pm UTC](https://forum.inductiveautomation.com/t/whats-the-ideal-computer-to-run-factorysql-and-factorypmi/21 "2006-04-01T19:13:14Z")
Should I use the same machine for both FactoryPMI and FactorySQL? What should I be concerned about when planing a server? [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=58) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=60)