Showing posts with label Access97Runtime. Show all posts
Showing posts with label Access97Runtime. Show all posts

Monday, April 08, 2013

Don't Steal My Freeware!

I write software for a living. Yet in my spare time I publish useful freeware utilities that I think the Windows community or developers at large may find useful. This is my way of thanking others for sharing their expertise with me. But just because the software is made available for free, doesn't mean it isn't copyrighted.
Recently I was on the phone to a client and needed to look up some information on my SMSQ freeware program. Rather than typing in the URL I did a Google search and to my horror discovered that some random web site called Software Informer had taken it upon themselves to list some of my utilities on their site, and make them available for download. I was horrified.
How dare they? They didn't ask for permission, their listings are incomplete and badly written, and they don't even have the decency to provide an honest link to the original page. I sent a letter to the address provided, and got the following boilerplate reply from some jackass called Kasey Bloome:
Dear Donn,
Please, try considering first what we are:
We (software.informer.com) do not sell anything at all. Our software database serves solely as a source of information; for that purpose, under each software entry, we only provide links to sites run by the actual developers (or copyright owners) of that software - including the download links (if there are any). None of the listed programs (with the only exception of 'Software Informer Сlient', developed by us) is hosted on our site physically or offered as an illegitimate download in any other way.
Each program gets into our database automatically after it is installed by at least one user of siClient (http://software-informer.software.informer.com/). That is, a user clicks 'Refresh' in the client, and our site gets the info about the existence of the new program.
The description (until the program is reviewed) is obtained from the program's PAD file. Alternatively, you can use a link "Suggest a correction" available at the program individual page to change all the information you see fit.
Please, read more about our service at http://software.informer.com/help.html
and about using our siClient: http://software.informer.com/help/
If you still insist on removing any reference to your software, please let me know.
Best wishes,
Kasey Bloome
partners@informer.com
Needless to say I did let them know, and they have done nothing, other than continue to knowingly violate my copyright.
So why get into a big froth when the software is free? Well, firstly, their poor quality listing is a bad reflection on the quality of my software. Secondly, the links links they provide are bogus: Their link to Playsound looks like this:
http://software.informer.com/go/go.php?n=877768&go=http%3A%2F%2Fwww.openaccess.co.za%2FBlackAndWhiteInc%2FPlaySound.htm
instead of like this:
http://www.openaccess.co.za/BlackAndWhiteInc/PlaySound.htm
This is the form that search engines use to provide page ranking. So not only are they making money out of my site, but they are burying the original site in the search listings. It sucks.

And in spite of their public assurance that they only provide links for the download, they also provide a mirror download:
http://download.informer.com/stor/276791/playsoundsetup.exe
i.e. they lied. Kasey Bloome is a liar and a thief.

They also mention the use of a PAD file: not one of my programs uses such a file. So as far as I can see they are happy to deliberately violate my copyright, lie to me, and ignore my complaints. What's more, their SI Client program spies on the user's list of installed programs and reports these back to the web site. In most circles this is known as Spyware, and is actively discouraged and removed by honest users.

Update 1pm: It seems that the people at Software Informer have had their own software copied. Serves them right.
Update 3pm: Casey Bloome wrote:
All the products of your company have been successfully removed from our site. We apologize for the delay and any inconvenience this may have caused.
But the illegal mirror download files are still there, and my company name is still listed. More ducking and diving, but then I expect nothing less from this kind of scumbag.

Update 5pm: It's not only Software Informer that has been doing this kind of thing, although they are by far the worst. I have also sent email removal requests to:
Then there are the more difficult ones to contact
I have also had to re-engineer my web site to check where the download is coming from, and then either allow the download or not. What a pain. I have replaced all the static EXE downloads with my BOFH program, which generates random meaningless error messages, such as this one:

See also: "There is only one AccessOpener" written 5 years ago.

Tuesday, November 18, 2008

Access97 SR-2 install on Windows Vista: a workaround


Microsoft Access97 works fine on Vista, once you can get it to install. My original install CD is the SR-1 version, and I was alarmed to discover that the SR-2 patch doesn't work on Vista, because Vista's new security model prvents the patch from updating the program files. How do I install the Access 97 SR-2 patch? Fortunately there is a workaround.
I used my old testing laptop and created a WinXP install, and then installed Access97, the ODE Tools, the print relationships wizard, and the service packs for both ODE and SR-2. Then I backed up the files onto an external drive. The folder I used for Access97 was c:\Program Files\Office97 so that these files don't get mixed up with newer versions of office.
Next, I created an install script using Inno Setup, based on the log file created by the SR-2 patch program. After creating and running the setup program, my copy of Access97 reports that it is indeed version SR-2, as shown in the screen shot above.
If you want to use this patch, then you must have done the following:
Delete the HATTEN.TTF (Haettenschweiler) font, and then install Access97 SR-1. I have not tested the install with a pre-SR1 version. Run Access97 SR-1 as administrator (just right click on the shortcut and select "Run as administrator") to ensure that Access has correctly set up all its registry entries.
Only once you have completed these steps is it okay to download and run my Access97SR2Setup.exe file (25MB). Alternatively, you can download the Access97sr2.zip file which contains a copy of the Inno Setup script file. Don't be confused: you can't use this script to actually install Access97 without an original Access97 or Office97 CD, because the script only updates existing files. If you want to install the Acces97 Runtime tester, then follow the link. The runtime version only allows you to run Access programs, not edit Access databases. Also, my installer does not patch Word, Excel, etc.
Update: after installing the patch I have stopped getting a weird compile error when creating MDE files. I guess it was fixed by one of the SR-2 updates or the ODE service pack fix.

Tuesday, April 08, 2008

There is only one AccessOpener


I'm sure they meant well, but earlier today someone posted a copy of my Access Opener freeware program on a software catalogue site without my knowledge or permission.
It seems that he/she isn't the first offender. Also CNET's downloads.com site, ZDNet, and the TechRepublic site have done the same, again without my permission. I don't mind if people link to my page, but I can't be expected to run around the internet trying to get sites to update their servers to the latest version as well. Please stop it!

Update 5 years later: Don't Steal My Freeware! Some people just won't learn.

Friday, August 03, 2007

AccessOpener 1.20 now supports Access 2007

Microsoft Access 2007 has been available for some time, but I only recently downloaded a trial version to experiment with. As a result I can now announce version 1.20 of AccessOpener, the utility that allows you to open an Access file with the same version of Access as it was originally created, assuming you have it installed on your PC.
The biggest problem with getting the new version to work was Access 2007's insistence that it is the only Access program on the PC, which wasn't true. I kept getting the screen shown below:
It took several attempts to eventually figure out why Access 2007 was doing this, and the new version of AccessOpener seems to work correctly with Access 2007. I have not been able to test it with Access 2003 or Access 2000, but it still works properly with Access 2002 and Access 97 on Windows XP. I suspect there will be trouble with Windows Vista, but haven't been able to confirm this yet.
I have also improved the "train" function, which should make setup a bit more simple. The installation program is also a bit more intuitive. Please report any bugs here or write to me directly.

Monday, June 04, 2007

AccessOpener 1.11 gets a boost

If you're an Access programmer you need this free utility. I use it all the time, and it saves me a lot of trouble. It's only when it isn't there that I miss it the most, like when my laptop had to be reinstalled, or when I'm working on a client's machine.
Recently I learnt a lot more about the Windows Prefetch system, and encountered the DiskTrix SystemBoosterXP product, which got me thinking: why not use AccessOpener to read the msaccess.exe file from the disk and place it into cache memory while the computer is booting up? Once it's there it will speed up the time it takes to load Access and open a file.
So I added a /LOAD option to work with the /SET option at startup, and it's all packaged and working, thanks to Inno Setup.

Sunday, March 25, 2007

Updated Freebie Software Page

Visitors to the Black and White Inc site have probably looked that the "freebies" page to see what is available for download.
I have just spent a productive Sunday morning updating the list of software that I have installed and use regularly on my PC. Here is the list:
  • 7Zip: (freeware) is largely better than WinZip in the variety of formats it can handle.
  • Access Opener: (myware)
  • Access Runtime Tester: (myware) The simplest way to repair and compact or decompile an .mdb file.
  • Ad-Aware SE Personal: (freeware) is largely obsolete because NOD32 does such a good job.
  • Adobe Acrobat Reader: (freeware) displays all the PDF files I use
  • allSnap: (freeware) keeps the screen from getting cluttered.
  • CCleaner: (freeware) keeps the hard drive from getting cluttered.
  • CmdHere Powertoy: (freeware) Useful for getting a command line where you need it.
  • Cool MP3 Splitter: (shareware) Useful for managing large MP3 files.
  • Contig: (freeware) from Sysinternals allows me to defragment an individual file from a batch file. Doesn't replace PerfectDisk, but helps keep the drive tidy.
  • DS Clock: (freeware) Those chimes are just so cool and you get to decide how the time displays on your desktop.
  • eMule: (freeware) with the XtremeMod extras. It's the best way of doing file sharing without all the spam and bogus files.
  • Goldwave: (shareware) is possibly the most useful audio editor available.
  • Google Desktop: (freeware) finds stuff fast, particularly in Outlook
  • Google Earth: (freeware) a great way to look at the world
  • Google Pack Screensaver: (freeware) allows me to view some of my photos when the PC isn't busy.
  • Google Toolbar: (freeware) indispensable for both IE7 and Firefox
  • Hamachi: (freeware) the simplest way to set up a secure VPN
  • Hunter-Killer: (myware) keeps the clutter to a dull roar.
  • Inno Setup: (freeware) incredibly useful setup program
  • ISTool: (freeware) the toolkit that makes Inno Setup so easy to use.
  • iTunes: (freeware) a necessary evil when using an iPod Shuffle.
  • Jasc Paint Shop Pro 8: (commercial) programmable and easy to use most of the time.
  • JGsoft Editpad Pro: (commercial) totally indispensable text editor.
  • LogMeIn: (freeware) great for connecting to remote machines.
  • Microsoft Access97: (commercial) my favourite database application, bugs and all.
  • Microsoft Developer Edition Tools: (commercial) used to make the runtime stuff. Inno Setup does a better job, but this licenses you to deploy Access runtime apps.
  • Microsoft Office XP Developer: (commercial) what a waste of a lot of money. I use Word and Excel, and have yet to write any AccessXP apps.
  • Microsoft SQL Server 2000: (commercial) comes with Office XP and allows me to test the SQL apps I write with Access97.
  • Microsoft Visual Basic 6.0 Professional: (commercial) I don't use it much, but it is still a great programming tool.
  • miFiles - My Internet Files: (freeware) a simple, effective FTP program. I love it.
  • Mozilla Firefox 1.5: (freeware) my browser of choice, especially with the following add-ins and extensions:
    • NoScript
    • Google Toolbar
    • Adblock
    • FasterFox
    • IETab
    • DownThemAll
    • ForecastFox
    • FoxClocks
    • PDF Download
    • Print Preview
    • Googlepedia

  • Mustang: (betaware) Mustang 4.x is the basis for the Miami applications I develop every day. No longer available.
  • MyMail: (myware)
  • NOD32 Antivirus: (commercial) keeps my PC virus-free and safe.
  • PerfectDisk: (commercial) keeps my hard drive in order
  • PerfOpt XP: (freeware) allows me to tweak some Windows settings
  • PKZip Command Line: (shareware) used with Zippy to make backups
  • Plaxo Toolbar for Outlook: (freeware) helps keep my contacts up to date
  • PsShutDown: (freeware) from Sysinternals allows me to shut down or Reboot from a batch file
  • Putty: (freeware) the Telnet client I use when I need to talk to my Ubuntu Linux server.
  • PrimoPDF: (freeware) is the best way to create PDF files.
  • Radmin Viewer 3.0: (commercial) indispensable for keeping client PCs organised and operational.
  • RealPlayer: (freeware) for playing Audible books
  • SafeXP: (freeware) tweaks Windows XP to make it a bit more bearable.
  • Search and Replace 2.87: (shareware) I bought this ages ago and its still a quick way to find and replace things across multiple files.
  • Skype: (freeware) great for long distance conversations
  • Snadboy's Revelation: (freeware) useful to test security and find lost passwords
  • SyncToy: (freeware) great for making backups
  • Total Recorder 6.0: (commercial) Standard Edition used to convert Audible books into MP3s and for recording Skype calls.
  • TrueCrypt: (freeware) keeps confidential data safe and secure, especially on laptops.
  • TweakUI: (freeware) helps control Windows.
  • UniBlue Registry Boster: (trialware) Compacts the registry, and supposedly finds registry errors. CCleaner works better. Not worth the money. Uninstalled and replaced with Auslogics Registry Defrag.
  • UniBlue SpeedUpMyPC: (trialware) removes miscellaneous files and allows me to monitor hard drive activity. The Memory Boost option is completely bogus. Not worth the money.
  • United Devices Agent: (freeware) Uses spare processor cycles for scientific work at grid.org
  • WavePad: (freeware/commercial) has a great Automatic Gain Control and is useful for converting audio books to my personal MP3 standard format: 32kbps, 22050Khz.
  • WinAmp: (freeware) plays most of the media files on my PC
  • WinZip 9: (shareware) the best ZIP file program, but I won't be spending more money for version 11. See 7Zip.
  • Zippy: (myware) makes backups of my work. Has saved me days of lost work over the years.
Digg it if you like it

Tuesday, March 13, 2007

Finally! Access97 Runtime installs correctly thanks to Inno Setup

If you've ever struggled getting an Access97 Runtime installation to work correctly, you'll know what a black hole it is. First you have to buy the ODE Tools, and then the Setup Wizard uses files from your current system installation (not good) and even then the installation is incomplete.
As a result, a lot of Access 97 installations end up having unlicensed copies of Access97 Professional installed, simply to get the darn thing to work. This is no longer necessary, thanks to the brilliance of free software called Inno Setup. I downloaded the "QuickStart Pack" that has an incredibly useful utility called IStool. Then I found a German script for Access97 Runtime, and used it to learn how the whole things works.
Finally, I tried it out on my own software, and added in some additional features. Firstly, it had to install the Visual Basic 6 runtime libraries as well, along with the MouseWheel.dll and MyWeb.ocx files that I use in all my Miami applications. Next, it had to be able to display GIF and JPEG files correctly in Access, something that is left out of the ODE Setup wizard completely. It also had to create shortcuts that work, and install the required fonts if missing.
The end result is a 14.7MB install file that correctly installs the Access97 Runtime libraries, the associated graphics display files, ODBC drivers, some ISAM drivers (not tested) and the Graph display drivers. I went to a lot of trouble to get the correct versions of each of these files, so as not to mix Windows XP files with Windows 98SE files. I have completed the testing on a fresh install of Windows 98SE, and will be doing the same test on Windows XP Pro later.
Update: Testing on WinXP has been completed, and the setup program and script adjusted to set the correct permisions on the install directory.