Log in

No account? Create an account
Database stuff - Dave's Ramblings — LiveJournal [entries|archive|friends|userinfo]

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

Database stuff [Nov. 6th, 2012|10:31 pm]
[Current Location |Invercargill]
[mood |accomplishedaccomplished]

I have been performing grotesque experiments on cute, innocent little databases lately and it looks like I've finally figured out a workable structure for one of my projects... but while doing so I've also noticed that Microsoft Access finally does something I've been wanting it to do for... probably just about all the time I've been using it.

The other night I changed the name of a couple of tables in a little database I'm going to split up and experiment on, and expected to have to, as I have always had to in the past, go into all the queries and reports which use data from that table and change each of the query and report fields from the now non-existent tables to tables that actually exist.

Except I didn't have to. Access had actually realised that the table name had changed and had done all the moving of links automatically.

This may sound like something that it should have done in any case, but all older versions of Access I've used wouldn't do that; they'd lose the links and need to have them all manually reinstated.

It is quite a red-letter event for something involving a Microsoft program to actually work. Maybe one of these days Access can actually pass itself off as being relational and I'll be able to start ignoring the database snobs who keep on telling me that I Shouldn't Be Using Access But Instead I Should Be Using One Of Those Big Expensive Database Programs That Will Take Me Ten Years Just To Learn The Language For.

[User Picture]From: southerndave
2012-12-11 08:23 am (UTC)
The story as it was told to me was that it's a 'feature' of the way union queries work (possibly only in Access) that the program doesn't know which of the multiple tables each row of data comes from, so it can't go back and edit it in the original table. Sounds annoying but I'll see if I can adjust what I was planning on doing so that it still vaguely works (e.g. using the union query just as a quick key off to one side while I work on multiple tables).

... I am one of the database administrators at work. This fact either amuses or terrifies people who know me.

Not surprised... I try to avoid other stuff that feels too much like work as often as I can, too.

I've got the first batch of cards off and will be sending another batch in the next week or so (as the first cards I sent were on Friday 7th, and the overseas mails closed on Monday 3rd, they probably won't show up until the New Year... but that's the way things go). If it's OK with Kat and Jesse you can pass me their new address (probably better check with them though, the last I saw of Kat she was taking offence at me saying something that was mildly, I thought, critical of one of the politicians up in your hemisphere).

The address I've used for the last few years is valid... I've just had a quick check and at least one of your emails to me has survived the mass email failure of the start of this year and it's gone to an address that's still current (and will be for the foreseeable future).
(Reply) (Parent) (Thread)