Hi been thinging of a database for a while just didn't now how to do it.

Would you or anybody else have a template for a database, I would be using access 2003, if it is not asking to much it will save me a lot of work and time my email is salesgpo at bigpond dot net dot au.

Thanks

I know i responded with corrected to this, but have done some further confirmation and seems 1 million plus is correct, the beta version may be at 65536 but the full version is as such.


my question

my answer from a respected source


CP lets just hope they have also improved on the stability issues as well and it proves a better package for all.

have a look for templates in office there should be an example template to learn from, or type examples into the help section ( from access ) and there are many that can be downloaded
cheers

I stand corrected, the Beta version did have 65,536 rows.

Excel 2007 will have "support for" 1 million rows and 16,000 columns.

I certainly won't be upgrading!

Let's have a guess how many Service Packs they release for it?

Two, Three?

I reckon Four at least, the file system is just not built to handle this kind of storage. They have improved the theme, the feel, the look, and a few add ons, but the basic file structure is the same.

Isn't it strange that M$ know themselves that the spreadsheet file structure is not suitable for large storage, and told me so on more than one occassion, by phone and email, recommended large amounts of data be kept in Access, then release 1 million rows with no changes to the actual file system, just feel-good stuff.

Welcome to Microsoft Online Crash Analysis

Anyway, I was wrong on that issue, 1 million it is.

__________________
RaceCensus - powerful system testing software.
Now with over 402,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/05/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Hi!
Just tell me what fields (like horse-name, race number, venue etc) you want included and I design one for you and send it over to you, as an empty, ready to use database, it's easy as.
Cheers

Thanks for the suggestion Chrome, but unfortunately what I was doing was a little too complex for such an elegant solution.

I agree that arrays can be painfully slow and also at times I found them very tricky to use. On more than one occasion they have downright refused to work correctly for me and blowed if I could ever work out the source of the problem.

Wunfluova