dbQwikEdit 3.4.0.0 Adds Office 2007

Today we release dbQwikEdit 3.4.0.0. In this release, we add a few new features that some users have been looking for as well as the regular set of bug fixes to known issues.
The two highlights of this release is a reworked connection wizard and Office 2007 support.
Building ADO connection strings easier than ever using the new connection wizard. That said, sometimes easy just doesn’t go far enough. Our power users have been demanding more control over their connection strings. The new connection wizard opens the door to entering connection strings manually.

The other major update is the addition of Office 2007 support. What does “office 2007 support” mean? It means that dbQwikEdit can now work comfortably with MS Office new “x” file formats. When using MS Access you work with accdb office 2007 formats in addition to the classic mbd files. MS Excel xsl and xslx file types are both supported in this release of dbQwikEdit.

If you are not a MS Office user yet, there are still a slew of bug fixes that make upgrading worthwhile. We clean up some exceptions and fixed some irritating bugs. Some of these bugs include: inability to modify primary keys in some cases, adding fields sometimes missed the “not null” option, specifying lengths of MS Access text fields at times was missing and a few minor tweaks to the data grid.

Existing version 3 users can get the latest release by running live update from the help menu, new users or users of older version can get more information about available upgrades at www.dbQwikEdit.com

dbQwikSite 5.2.1.7 –Paves the way to a New Edition

This week we released dbQwikSite 5.2.1.7 this is a maintenance release with a few bug fixes and minor enhancements. Hardly worth writing about, except for the reason behind the release which is far more exciting news. We released this edition because it contains fixes that we wanted to get to the user community, before dbQwikSite undergoes a major change to the code generation engine. This change will introduce new, powerful of functionality for web designers and web developers.


What’s it all about? You’ll get a hint if you upgrade to version 5.2.1.7. In some of the property dialogs, version 5.2.1.7. In some of the property dialogs, you’ll see a new option tab “Custom Events.” This is the essence to an all new “Developer’s Edition”. The Developer’s Edition adds the ability to incorporate your own custom code into your projects. It will offer both “client-side” and “server-side” script support. This means that you can add your own JavaScript to run the browser or add ASP(.net) or PHP code that will execute on the server. We introduce “events” and “insertion points” in this edition. You can add your own code at any of these points to change or enhance generated pages.


If you are a designer, you likely have seen, or used, JavaScript to do such things as create rollover effects, validate form fields, and highlight errors or other dynamic HTML effects. With Developer Edition, you can use provided JavaScript functions or incorporate your own scripts that you write or download from script sites. Web developers familiar with ASP(.net) and PHP can insert their own code “snippets” to change processing on the server side. For example you could change the security authorization or perform server-side validation or calculations. Having the ability to add your code to dbQwikSite code opens the door to creating even more advanced, highly customized applications. Unlike editing the generated code which is overwritten if you regenerate a page, embedded code is preserved between code generations.


Stay tuned to this blog from more breaking news about dbQwikSite Developer Edition and other news about dbQwik products.

dbQwikMySSH 1.0.0.4 - Painless MyODBC SSH Management

We just introduced dbQwikMySSH only a few short weeks ago and it is doing very well. This week we released a minor update to make it even easier to use. We added a new function to automatically reconfigure your MyODBC connections to pass through the secure SSH tunnel. Restoring them is just as easy. You simple right click the connection to secure, and choose the Secure option in the popup menu. To restore connections to their original settings you right click a secured connection and choose the Restore option.

There are a couple of other tweaks to the interface to make it easier to understand what’s going on. For instance the MySQL server detection is easy to confuse with your connection settings. The Server check is just to see if there is a MySQL server listening; it does not have anything to do with the authentication of your MySQL connection. So we have refined the interface a bit to try to make that a bit clearer. A couple of small bug fixes are included to round out this release. If you are installed and want to get the latest, you can run the live-update. Otherwise just download the latest install from: http://www.thedevshoponline.com/dbqwikssh.html it has the latest updates.

TheDevShop Finalist in the "Red Herring 100 Asia" Awards 2007

Today TheDevShop, makers of dbQwik products, got some some great news. We have are among the 200 Finalists in the "Red Herring 100 Awards". The awards are for "The Most-Promising Private Technology Ventures" in Asia.


Here's an excerpt from their Press Release:
San Francisco, CA, August 7, 2007 – Red Herring Magazine announced today that TheDevShop Ltd. has been short listed forerunners of the Red Herring 100 Asia 2007 awards. The 100 winners will be announced at the Red Herring 100 Asia event in Hong Kong, on August 29-31.

The Red Herring editorial team carefully selected the finalists based on criteria such as (please check the FAQ for the 5 criteria). The 200 finalists are based in 16 countries/regions including China, India, Japan, Singapore, Korea, Australia and Vietnam. The names of the 200 companies short-listed as finalists for the "Red Herring 100 Asia 2007" can be found online here

"The 200 finalists we selected from across 16 countries and regions are all excellent contenders," said Joel Dreyfuss, Editor-in-Chief of Red Herring. "They are exceptional companies who thrive on innovation and strongly define the important role of technology in Asia’s economy and throughout the world."

For us, this is pretty exciting. It's great to know that we rank among the top 200 technology companies in Asia. So if you ever wondered "Just what kind of company is TheDevShop?" this may help you put us in context.

dbQwik™MySQL2Access v 1.0 – Moves MySQL to MS Access.

This week we introduce a brand new member to the dbQwik™ family of products. dbQwik™ MySQL2Access is a program that moves MySQL databases into MS Access. It can either connect directly to MySQL or it can read in MySQL dump files. The program can either create new MS Access Databases or import into an existing MS Access Database. You can selectively import tables.

The program is very simple to use. Enter your MySQL login details or browse to a MySQL Dump File. The tables are listed, and you just pick the tables to import and all rest is done for you.

This program is great for creating local copies of local or remote MySQL databases. Local copies can be used as back ups, or “off-line” copies for reporting and anlysis. The advantage of MS Access is that it is highly portable and integrated into MS Office. There is no need to install MySQL in end users PCs. This is a handy little utility that you can use again and again if you have data in MySQL.

dbQwik™MySQL2Access is available for download from our software store: www.TheDevShopOnline.com. There is a free trial version. The trial has an import limit of 25 records per table. You can buy the full version for only $19.95.