Help needed for creating a database please
Posted 10 November 2001 - 07:01
What I was thinking of doing was to create a Database in Access, which would allow me to add details concerning each particular race as I went along. For each race I would have the official results as well as somewhere where I could add information when I come across it and maybe pictures as well.
I have a basic knowledge of Access but have never tried something like this. I know other readers have mentioned that they have Databases concerning specific topics or periods. Any hints or suggestions on how I should go about it would be greatly appreciated.
Posted 12 November 2001 - 19:52
Oh dear, can't you see? It's them it's not me
We're not enemies, we just disagree
If I was like him all pissed in this bar
He changes his mind, says I went too far
We all disagree
I think we should disagree, yeah
Is This It - The Strokes (2001)
Posted 12 November 2001 - 23:19
Access is not that hard once you -- I even hate to say this -- read the book and work with it. I find it very, very good and will not even look at Excel for this sort of work. It is very powerful and yet very easy to format and run.
I recommend you set up a small database to play with and then stretch the envelope. I think you will be pleasantly surprised.
Posted 13 November 2001 - 05:33
A few months ago I saved it as text and tabs so I could do a word count on it - it was 2.6 million words! It has grown a lot since then.
It is just on 20 Mb in size. And it works for me; I can sort it in all sorts of ways.
Whenever I have tried to use Access, I have found it doesn't work as well for me. I did convert this file to Access and there were some report features I liked, but I went back to Excel.
A friend told me, also, that Access spits the dummy with files this large, so I didn't want to take any chances. A case of "the devil you know..."
But I am concerned about its reliability as it grows even larger. A worksheet has a maximum of 40,000 entries and I will pass that mark very soon.
I am not ruling out Access; I still have a feeling that it could be better, once used to it, but I have no complaints about what I have now.
Posted 13 November 2001 - 06:36
You're also likely to run into problem with Excel if you have more than one large table and try a lot of cross-table linkage.
Posted 13 November 2001 - 09:06
Posted 13 November 2001 - 09:44
I would seriously suggest that you consider Microsoft Access as the tool of choice here, especially if you want to include pictures.
Until recently, I developed custom database systems for a living. By prefference, I worked with MS SQL server but, failing that, the Access data engine gives good stability and performance on a single PC platform. The only time you are likely to experience difficulty is if you want many people to access the data at the same time over a network. Access, while quite capable of this, does not perform particularly well in a multi-user environment.
I would guess that, given the number of races between 1918 and 1939, you may land up with a lot of data and I really think Excel would be inappropriate.
If you are comfortable with writing VB code, you may want to consider doing the program in VB with a Microsoft Access back end. I would suggest that you play around with Access first, however, and explore the VBA capabilities which it has before moving on to a full VB development environment. I think you will find Access both efficient and easy to use compared to many other database packages.
The best way to learn is to go and get yourself one of the Step by Step guides which should be stocked by any good book shop.
Posted 13 November 2001 - 10:34
Posted 13 November 2001 - 12:45
The MS Access database holding my racing data is inherently stable, and is currently 38Mb - Just the tables, I keep queries and reports in a separate database and link to the tables.
Like Andrew, until recently, I've been writing software for a living, and I don't think that Excel is the way to go either. I've had a lot of Excel crashes, but very rarely Access. Access data is safed when you movedaway from the current entry line, so Access crashes (not many in my experience) mean you lose 1 line at most.
Also, remember that Access databases to not shrink when data is deleted, and thus grow and grow if you keep adding data... UNLESS you Compact the database regularly.