Monday, March 30, 2015

Workaround for An INSERT INTO query cannot contain a multi-valued field

Access multi-valued fields can be useful but sometimes they can cause problems working with the database. If you eventually would want to move the database to SQL Server you will need to redo certain things so related tables are used instead. This article describes how to solve certain things of this Access-only feature.

The article says: In Office Access 2007 (same with newer versions like Access 2010 and Access 2013), you cannot use an append query that references a table that contains a multivalued field. For example, the following query is not valid:

INSERT INTO NewIssues ( ID, Title, AssignedTo )
SELECT Issues.ID, Issues.Title, Issues.AssignedTo
FROM Issues;

An INSERT INTO query cannot contain a multi-valued field.

Here’s the Issues table:

Depending on what you want to achieve this two step workaround could be an option. First use an append query like this that does not reference any multi-valued field:

INSERT INTO NewIssues ( ID, Title )
SELECT Issues.ID, Issues.Title
FROM Issues;

Resulting in:

Followed by an update query like this that does contain the multi-valued field AssignedTo:

INSERT INTO NewIssues ( AssignedTo.Value )
VALUES ("Lisa")
WHERE NewIssues.Title In
(SELECT NewIssues.Title
FROM Issues INNER JOIN NewIssues
ON Issues.Title = NewIssues.Title);

Final result:

Wednesday, March 25, 2015

JTB FlexReport 9.0 released

JTB FlexReport 9.0 is now released and available. JTB FlexReport is a solution for monitoring network license usage and software usage in general. With its reports you are in a better position to know the actual usage of often expensive licenses. You will easier predict when and how to handle the need of increases or decreases of your licenses.

JTB FlexReport Core, JTB Process Monitor service and client, and JTB SPLM service and client are updated. JTB FlexReport Chart Service and Client will be updated soon but we wanted to get out what’s ready first.


Here are some of the main news:

  • DSLS support added including import of historic logs and denials.
  • The SLM tab is renamed to SLM/RMS and adds improved functionality for Sentinel RMS. AVEVA Licensing System fully supported.
  • SPLM 2012 support added.
  • Altium license monitoring support added.
  • JTB Process Monitor updated to handle idling of processes with detection of usage of an application if mouse movement or keyboard usage is detected for the application or if the CPU usage for the application exceeds a specified level.
    This way you will get a better picture of how much the applications really are being used as sometimes an application can be running the whole day but only being used an hour or so. If monitoring network licenses both with JTB FlexReport Core and JTB Process Monitor you will now see that they match better, especially if you’re making use of TIMEOUTALL or TIMEOUT on the FlexNet license server.
  • JTB Process Monitor can now detect if different AutoCAD verticals are running even though they use the same acad.exe by the added title filter. Thus you get a report on AutoCAD 2016 as well as AutoCAD Architecture 2016 separately.
  • Added automatic reading of user and host names from AVEVA’s ALS XML.
  • Several improvements and bug fixes related to 12D usage monitoring.
  • Added support for showing user group information on the HTML report grouped on servers. User groups are first taken from the FlexNet options file if it’s been specified on the FlexNet tab, otherwise from user groups defined in the Group Administrator.
  • Added support for SLM based licenses to show up in the HTML reports and also log feature usage to the ‘log’ table.

For more details see the revision history and download here. Trial is also available.

Monday, March 23, 2015

DimensionPatrol 1.3 for AutoCAD released

JTB World’s DimensionPatrol for AutoCAD has been updated with bug fixes and support for AutoCAD 2016. DimensionPatrol is also available to try or purchase at Autodesk Exchange Apps.

This plug-in highlights dimensions in a drawing for which the user has customized or edited the dimension text and helps to ensure the quality of the drawings.

Manually overridden dimension are highlighted in red by the DimensionPatrol plugin.

DigSigStamp 1.3 with support for AutoCAD 2016

JTB World’s DigSigStamp for AutoCAD has been updated with bug fixes and support for AutoCAD 2016.

  • This plug-in allows you to specify a block that will change its display when plotted to indicate whether the drawing had a valid digital signature at the time of plotting.
  • The DigSigStamp plugin helps you identify visually when drawings have valid digital signatures. You use one of the plugin's commands to specify blocks to display when a drawing has a valid digital signature and when it does not. You then assign a particular block reference - which usually exists in the title block of your drawing - that will change its display to one of these two block definitions depending on the state of the drawing. The application even works when plotting, an operation that typically invalidates a drawing's digital signature.
  • Available as AutoCAD App (Plug-in) on Autodesk Exchange Apps to purchase or to try.

The following is an example of how the block can look like. The design of them is completely up to you. This drawing has a valid digital certificate.

Friday, March 20, 2015

JTB Change Title for AutoCAD freeware released

JTB Change Title for AutoCAD is a freeware from JTB World that just been released.

Sometimes there can be a reason why you want to change the application title in AutoCAD. It can be that you need to take nice screenshots for documentation for example. In my case I could not right now register the new AutoCAD 2016 as it’s just been released an Autodesk is probably not yet ready with the registration part of it. Instead of showing "Autodesk AutoCAD 2016 - UNREGISTERED VERSION" or "Autodesk AutoCAD 2016 - NOT FOR RESALE" you want it to show "Autodesk AutoCAD 2016" or something else. With JTB Change Title this can be done.



AutoCAD 2016 released, what’s new?

Autodesk AutoCAD 2016 is now released. You might already be able to download it from your Autodesk Account. This is the 30th version of AutoCAD.

There are a few nice news added that you might find useful. Revision Clouds are easier to create and modify. Using the REVCLOUD command the new Modify options makes it possible to draw new revision cloud segments as well as erase selected portions of existing revision clouds.

I will keep updating the AutoCAD 2016 page with more about this new version as well as make some blog posts about specific new or updated features.

A good thing is that the file format is still the same old DWG 2013.

Most custom programs that work for AutoCAD 2015 will also work in AutoCAD 2016. In near future all JTB World apps will be updated to fully work with AutoCAD 2016. Several apps on Autodesk Exchange Apps are already updated for AutoCAD 2016.

FlexNet version to be used for network licenses is JTB FlexReport works fine with it but you might need to copy the new lmutil.exe to the JTB FlexReport folder.

Wednesday, March 18, 2015

JTB FlexReport and ANSYS 16.0

Here’s a support email we got from a JTB FlexReport customer that can be useful for others that might run into this problem and want a solution to it.

We updated the ANSYS-License manager last month to the latest version, included in ANSYS 16.0. The latest ANSYS-License manager uses lmgrd.exe and lmutil.exe

After this update, JTB FlexReport didn’t show data about ANSYS licenses.

After updating lmutil.exe from to in the JTB FlexReport folder everything works fine.

In the next upcoming JTB FlexReport version lmutil.exe version will be included to make license usage reporting work for both ANSYS 16.0 as well as upcoming Autodesk 2016 products. In the meantime if needed you can manually copy over the lmutil.exe file.

Tuesday, March 17, 2015

JTB Current Folder 1.2 for AutoCAD released

JTB Current Folder version 1.2 for AutoCAD has been released by JTB World. Speed up navigation among your drawings and files you want to open, attach or insert with the dynamic shortcut to the current drawings folder within the places area in AutoCAD’s file selection dialog boxes.

Wednesday, March 11, 2015

JTB Steel for AutoCAD

JTB Steel for AutoCAD is an Add-in running inside AutoCAD, adding powerful command features to help you draw simple and complex steelwork frames and details efficiently.

You can select and insert Steel Sections from JTB Steel library to AutoCAD® drawing just as inserting blocks. You can draw Steel Frames just as drawing lines by 2 pickpoints. All created drawing objects are either blocks or dynamic blocks. Once Steel members are inserted, you can edit these using powerful editing commands located on Tools Palette.

JTB Steel includes advanced automation techniques for modifying dynamic blocks. This means that you can easily manage your drawings and quickly finalize your details. The below example was fully created using JTB Steel (this includes any alignment, rotation etc):

JTB Steel on the AutoCAD Plug-ins menu.

Read more about JTB Steel on the product page and download the trial.

Monday, March 2, 2015

Autodesk Network License Manager v11.12.1.4

Autodesk is preparing for their 2016 products like AutoCAD 2016 and Revit 2016.

“Autodesk 2016 products can obtain license from Network License Server – v11.12 and above. However, it is strongly recommended to upgrade the license servers to the latest version – v11.12.1.4 – when using 2016 products.”

Downloads for latest version is available here. And specifically for v11.12.1.4 here:


Mac OS X:


adskflex.exe, lmgrd.exe, lmutil.exe and lmtools.exe are all version now.

JTB World’s JTB FlexReport license monitoring tool has been tested with and supports this new version and is prepared to be able to get statistics of license usage and report on it for all Autodesk 2016 products.

Some of the latest blog posts

Subscribe to RSS headline updates from:
Powered by FeedBurner

Contact Us | About JTB World | Subscribe to this blog
JTB World's website | Website General Terms of Use | Privacy Policy
^ Top of page

© 2004- JTB World. All rights reserved.