Inmagic DB/TextWorks and Vista Virtualization

by Denise Bonin Monday, July 07, 2008 5:10 PM

This post is a follow-up to Peter's post Inmagic WebPublisher PRO and Vista Virtualization, but specifically pertaining to DB/TextWorks. 

I recently had a client who created and added a bunch of records to a new textbase located in a folder under Program Files on her Vista-installed laptop.  When it came time to move the textbase off her laptop onto another computer she zipped up all the textbase files, copied the zip file to her thumb drive and prepared to unzip the files onto the other machine.  With files unzipped on the other machine (an older XP-installed desktop computer), she enthusiastically went to show off her newly created and populated textbase. 

Much to her surprise DB/TextWorks produced a disheartening message indicating that the textbase was empty.  How could this be, she had 170 records in the textbase when it was on her laptop and she had copied every textbase file from the correct folder on her laptop.  I got involved and we looked this way and that way - on both machines - and there was nothing that we could see that could indicate that the textbase could possibly be empty (the .btx, .dbt and .occ files were rather large).

The ah ha moment came when Kathy suggested that Peter had posted something about this on our Blog - back in March 2008 (see above link).  I had skipped over that posting because it had referenced WebPublisher, but in fact it told me exactly what I needed to know.  To change the text and code slightly from what Peter posted:

For instance, say DB/TextWorks indicates that a textbase is located at:

%Program Files%\Inmagic\Textbases

Vista detects that DB/TextWorks does not have permission to save to that location and copies the file to:

%Users%\<your account>\AppData\Local\VirtualStore\Program Files\Inmagic\Textbases

Subsequent read/write operations access the VirtualStore version of the file, even though DB/TextWorks will still think it is accessing the Program Files directory. Poor deluded DB/TextWorks.

It took about 1 minute to find the database files in the VirtualStore location - thank you Peter! - however, there was more, or in this case less, to come!  Two of the essential files were missing.  They were the .tba file and the .sdo file.  Why those two? Who knows?  However, combining the new found files (.acf, .btx, .dbo, .dbr, .ixl, .log, and .occ)  from the VirtualStore location with the .tba and the .sdo file from the presumed location – under Program files, allowed us to complete the textbase and transfer it to another location. 

The lesson learned here:

  • On a Vista machine DO NOT install textbases under Program files. 

And a Note: 

  • this problem only occurs with Vista's UAC (user account control) turned on.

DB/TextWorks 11.0 Service Pack 1 now available

by Administrator Monday, May 26, 2008 9:50 PM

Inmagic, Inc. have announced that a service pack is now available for DB/TextWorks version 11.

This service pack includes fixes for the following issues.

  • Substitution lists where the code to the left of the colon is a single character do not perform the substitution
  • Several issues with Export Query Screen to HTML and Export Editing Form to HTML
  • A few issues with the HTML Preview feature in the Query Screen Designer
  • Added HTML Preview to available toolbar buttons for Query Screen Designer
  • Form Designer: addressed issue with "Large buttons on toolbars" option

The Service pack can be downloaded from the Inmagic Customer extranet at

One character problem in DB/TextWorks v.11 substitution lists

by Administrator Monday, May 05, 2008 5:35 PM
A problem has been identified in DB/TextWorks v.11, whereby single character substitution lists are being ignored. Inmagic recommends that you implement a workaround by using 2 or more characters instead of one. They have reported that this will be fixed in the next service pack or next release (no date given). Please contact Andornot if you need assistance in modifying your one character substitution lists.

Inmagic releases DB/TextWorks version 11

by Administrator Tuesday, April 01, 2008 9:52 AM
Email download notifications are now being sent out by Inmagic, Inc. for DB/TextWorks version 11 to all clients on the Inmagic maintenance program.

DB/TextWorks version 11 features include:
  • Microsoft Vista compatibility
  • Limited Undo in the Form Designer
  • File Checker to verify that files referenced on the local directory or network still exist.
  • Ability to select form for Edit Secondary Record window
  • HTML report preview
  • Dead URL Link Checker enhanced to allow the contents of the status field to be replaced or appended.
Compatibility: Version 11 can be used with WebPublisher PRO version 10. DB/TextWorks version 11 may be compatible with earlier versions of WebPublisher PRO but these have not been tested and are not supported.

Version 11 of WebPublisher PRO is due out in the next few months. No date has yet been announced for CS/TextWorks or CS/WebPublisher PRO version 11. For more information please see the Inmagic website.

If you have a current subscription but have not received a notification email in the next week or so, please email with your serial number and email address so it can be resent.

Please contact us if you would like assistance implementing these new features or want to renew an expired maintenance subscription.

How to install Inmagic DB/Textworks on Vista

by Peter Tyrrell Friday, June 15, 2007 5:05 PM

Right-click on the db/textworks installer. Choose "run as administrator". You may be prompted to proceed and/or enter administrative credentials, depending on your Vista setup. The installer will start installing and should work fine.

If you do not run as administrator, you will get an error like this:

Error 1925. You do not have sufficient privileges to complete this installation for all users of the machine. Log on as administrator & retry installation.

You may be confused by this message if you are logged in as an administrator. Welcome to Vista's User Account Control (UAC).

With UAC, you may have logged in as an admin, but you are not running as one. Instead you are prompted to elevate your permissions whenever you attempt an administrator-level operation. It so happens that Inmagic has not updated db/textworks to handle this scenario and give you fair warning. The error message it gives upon failure is at least completely accurate in its diagnosis, but leaves it up to you to manually elevate your permissions.

Here are some other Inmagic-on-Vista related posts on the Andornot Developer Blog:

Month List