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 database – latest additions

Ocean Grove Certificate of TitleI love original documents and there is nothing better than Victorian Certificates of Title – a real work of art and so full of information.  Sometimes people are dazzled by the front page and miss the massive amount of information on the reverse and subsequent pages.  To date, 17,036 transactions for land in “Old” Ocean Grove have been added to the Ocean Grove Land database together with a growing number of photographs for different properties.  These have been consolidated for the Geelong and District Database down to a total of 7,560 entries so far.

Since the last major update on 25 October, there are now 1,628,809 entries in the Geelong and District Database.  Latest additions include:

  • Geelong Infirmary & Benevolent Asylum: Annual Report 1882 – 1,300 entries
  • Geelong and District: Geelong Football Club players missing photographs – 209 entries
  • Surnames of Interest entries – 15 new entries [1,133 submitters in total]
  • Old Ocean Grove land titles: sellers and purchasers – 3,856 entries

Details on these indexes can be found in the Geelong & District Potpourri pages.

And don’t forget to search again for your ancestors in the Geelong & District Database – they could have been in the last load of additions!

Latest additions to database

Episcopal Chapel, Ballan - later St John's, Ballan.  Source: SLV IAN18/03/65/5/0More than 2,000 entries have been added to the Geelong and District Database since the last update.

More than three quarters of these entries came from a terrific book A Pictorial History of the Shire of Ballan – the index includes children named in school photos and names on various Honor Boards.

Those midwives keep popping up and are such a popular collection.  As I’ve mentioned before this is one of the few professions that help us track our married or unmarried female ancestors – they didn’t have to give up this role when they married.  Even better the Midwives Registers in the Victoria Government Gazette give us name changes [generally due to marriage] and address changes.  Once we’ve finished the Midwives Registers we’ll start on the Nurses Registers – another great source for our female ancestors and relatives.

Our Book indexes and Midwives indexes are the product of our wonderful volunteers in our region – some long-term volunteers and others who just pop up through Mailing Lists, Facebook, and of course this Blog.  They’re all wonderful!

This is the list of additions since 3 August making a total of 1,410,769 entries in the database:

  • Geelong District: Midwives from the Victoria Government Gazette 1931, 1945-1954 – 561 entries
  • Geelong District: Surnames of Interest – 20 entries
  • Ballan [book]: A Pictorial History of the Shire of Ballan – 1,558 entries

Details on these indexes can be found in the Geelong & District Potpourri pages.

And don’t forget to search again for your ancestors in the Geelong & District Database – they could have been in the last load of additions!

 

Follow

Get every new post delivered to your Inbox.

Join 575 other followers