Thanks guys for the responses. Skip, the data are added in rows, the columns remain the same.
I had wondered whether indeed I was going to have to go from Access to something else, so I'll look into the alternatives.
I have a large, single table database that keeps track of daily rainfalls from over 7000 locations around the country. This means that for every day, the year,month,day and station name are repeated. The database gets bigger each day and performance is being badly affected more and more (not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.