HIDEN.org

EDV mit System

Dec 08

MyAccess 1.6.2beta

As you might have noticed we stopped the development MyAccess. However there are still people using MyAccess.

Version 1.6.2beta now exists as a version for Access 2002 and Access 2003.
If you are using 1.6.1 and everything works then there’s NO need for changing to 1.6.2beta.
This version only fixes compatipility issues related to MS-Access.
If you want to make modifications to MyAccess then the current source code file is here.
Maybe someone would be so nice and test/port it to Access2007- Thanks !
If you make any modifications then I’d be happy if you share the code.
If you want to make modifications then please open the .mdb file and keep the <shift> button pressed. Now take a look at the autoexec macro or call from the direct window (ctrl-g) myaccess_start

Before trying MyAccess please make sure that MS-Access talks to your MySQL Server using MyODBC. Otherwise it's completly useless trying MyAccess!

In case you suffer from a Error 40230 then it's most likeley that you need to run a decompile. How to do that is described here

MyAccess

Nov 20

Disable Caps-Lock in Ubuntu

SysAdmin No Comments »

Caps-Lock is (IMO) the most useless and annoying key. Since there doesnât seem to be a GUI way for disabling just type the following in a terminal:

xmodmap -e “remove lock = Caps_Lock”

In order to make these changes permanent open your ~/.bashrc using

sudo nano ~/.bashrc

and add the line above

Nov 19

Kerio Mailserver with Thunderbird on Linux

SysAdmin No Comments »

The Kerio Mailserver is a great thing when accessed via Outlook from Windows. When it comes to Linux Clients it get’s a little bit tricky but it can be done.

I’ve setup the email client Thunderbird with its addon Lightning for Calender/Tasks

Email via IMAP
Simply specify your Hostname and Username/Password
Calendar/Tasks via calDAV
Add a new network calendar using calDAV with the address

http://<hostname>/calendars/<domain>/<user>/Calendar
Adressbook via LDAP
Create a new Adressbook with LDAP
Name: Your name but can be whatever you like
Adress: your server’s hostname
Base-DN:Â fn=ContactRoot
Port: 389
Bind DN: your emailadress
The only Drawback is that this Addressbook will be read-only

Nov 06

Open-Jacob CommandEntryPoints and Encoding

Open-Jacob No Comments »

I’ve written a small servlet that communicates with a Jacob Application through CommandEntry Points. Not the most elegant solution for sure but _very_ flexible.

When the servlet calls the entry point’s Url then we have everything UTF-8 encoded and additionally used URLEncoder.encode(URL).

On the jacob side the Data arrives as ISO8859-1 although everything in Jacob appears to be UTF-8. But a simple

String data1= new String(properties.getProperty("data1").getBytes("ISO8859-1"),"UTF-8");

does the job.

Nov 05

Bluetooth Network Connection between Palm Treo 680 and Ubuntu 8.04

SysAdmin 1 Comment »

I’m a proud owner of a quite outdated but otherwise extremly reliable Palm Treo 680. For software testing reasons I require a network connection from my Palm to a Ubuntu 8.04 box using bluetooth. Continue reading »

Sep 16

Open-Jacob and cascading deletes

Open-Jacob No Comments »

Open-Jacob (currently) does not support cascading deletes. Depending on the database used you could implement this at the database level but this would be no good idea since Open-Jacob itself keeps track of the data and could stumble when records are getting modified from another side.

Let’s assume the following database schema

relations

Sep 13

Dovecot and its Certificate

SysAdmin 1 Comment »

When installing the Dovecot IMAP Server on Ubuntu its certificate is only valid for a short time.
You can create a new certificate by issuing:

openssl genrsa -out server.key 1024
openssl req -new -x509 -key server.key -out server.pem -days 1826
sudo mv server.key /etc/ssl/private/ssl-cert-snakeoil.key
sudo mv server.pem /etc/ssl/certs/ssl-cert-snakeoil.pem
sudo /etc/init.d/dovecot restart

Aug 20

Recursively converting Files from UTF-8 to ISO-8859-1

SysAdmin No Comments »

I have a tomcat installation including a deployed mesh-cms (a really excellent thing btw ) Â When moving the whole tomcat from Linux to Windows mesh-cms looses my “german Umlauts”.Â The reason for that behaviour is described here.

What needs to be done ist do convert my utf-8 encoded files to iso-8859-1 is: Continue reading »

Aug 11

Building a Ubuntu PXE Install Server – Part 1

SysAdmin No Comments »

Being tired of installing Ubuntu using CDs (especially if you have a machine without a CD-ROM) I’ve built myself a PXE Install server. Continue reading »

Aug 03

Tomcat 5.5 and Ubuntu

SysAdmin No Comments »

Installing Tomcat from Ubuntu’s repository is a snap.

sudo apt-get install tomcat5.5

will do the job.
The only drawback is that when deploying .war files you’ll receive a error message when you call that application. Continue reading »