Aged 50 years in 50 minutes!

Geelong and District RegionLast night I was on a fast-track into the Guinness Book of Records – the oldest woman alive in Australia.

I thought it was about time to add some indexes I had to the Geelong & District Database as it had been a few months since I had done this.  More than 1.63 million entries live in an MS Access Database.  Indexes of all sorts to be added are compiled into an MS Excel spread sheet then copied and pasted into the MS Access form before uploading to the SQL database online.

Everything was honky-dory until I tried to paste – as I have done hundreds and hundreds of times before.

ERRORS – and nasty ones.  It wouldn’t even let me manually add a single entry!

What had changed since I last added entries?  I had upgraded MS Office to version 365 [actually version 2013].  I wasn’t about to uninstall the new version as that included months of University assignments but surely it was just something really simple that would fix the problem.

I had older versions backed up – didn’t come down in the last shower and I was able to update the database on the old Notebook running Vista.

Hours and hours of Google work showed I wasn’t the only one with problems but none of them were exactly the same – and certainly didn’t solve the problem.  By then I had about 8 versions I was experimenting with.

I then sat quietly and spoke quietly to myself saying there HAD TO BE a logical answer.  Then I tried attacking it from a different angle.  The Geelong & District Database is probably one of my oldest LIVE MS Access databases.  So I tried a new more recent one – NOT A PROBLEM!

I won’t bore you with the next four hours of experiments – I’ll just give you the outcome.  The MS Office upgrade should have converted the database to work in the new version.  True BUT NOT IF YOU HAVEN’T UPGRADED every time there was a new release.  I couldn’t afford that and so somewhere along the way where I didn’t pay for an upgrade until there were a couple of versions, it skipped a step that no longer works in the latest version.  Very convoluted but after another couple of hours I had all the data, queries, forms and reports working in a brand new database.  Basically I had to completely recreate the relationships as well as the Forms and Sub-Forms but I’m no longer heading for the Guinness Book of Records!

I’ve lost nothing [unless you count a bit of sanity], added the new indexes and uploaded the entries to the online database.

Haven’t had any sleep since last night but hey – IT’S WORKING!  What a relief.

Geelong & South Western Rail Heritage Society

Biregurra Railway StationI do love it when groups in our region progress to having a real web and blog site.  We have an addition to this category in the last month.

Obviously they still want to add more to their site but they are well and truly up and running and it’s worth checking them out.  The Geelong Rail Heritage Society web site includes an amazing range of up-coming tours and events.  They also have a great range of books / publications.

Congratulations and keep up the good work.

When and where was this photo taken?

OLYMPUS DIGITAL CAMERAThe Bellarine Historical Society presents Our Boys at War – a tribute to the local lads and indeed all soldiers that served in the First World War.

The Society has prepared a display in the Old Court House Museum to remember the centenary of the battle for Gallipoli.  Working in conjunction with the Drysdale RSL, the Historical Society is creating a ‘walk into the trenches’ display with memorabilia, photos, written articles and an audio/visual display pertaining to WWI.  [This photo was taken in the entrance to the Old Court House Museum in the last few days.]

Following a very moving RSL ANZAC Day remembrance service at the Cenotaph in Drysdale, a very special memento of Gallipoli will be moved into the Museum next door and the display will then be open to the public.  We hope that the whole community will take the opportunity to visit and remember those sacrifices so long ago.

The Museum will be open for this special display from 10:00am – 4:00pm both Saturday 25th April and Sunday 26th April, then the following 1st Sunday of the month in May, June and July between 1:30 – 4.:30.  We would also welcome contact by any schools or groups that would prefer a private visit during weekdays.

BendigoBankThe Bellarine Historical Society and the Drysdale RSL acknowledge the sponsorship and support of the Bendigo Community Bank for this project.

Further information can be obtained by phone Bob (0425 844 429) or Lynette (0417 133 177).