Search results

Has anyone discovered a tool for identifying redundant tables/queries/code etc?

Actually, I've just had a thought (doesn't happen very often), at the moment the query pulls in all of the associated data it needs to append to "tblRepBase_SyndNCFSummary" in one go by joining all of the tables together. Will the proces work quicker if I break this down into several update...

Here is the query: "INSERT INTO tblRepBase_SyndNCFSummary ( QtrID, Synd, YOA, Capacity, YrEndResult, SQRQtrlyResult, NCF, ActPerc, EstPerc ) SELECT RetCurrQtr() AS QtrID, tblSynds_SyndYearsMaster.Synd, tblSynds_SyndYearsMaster.YOA, tblSynds_StandingInfo.Capacity...

Pat, thanks for your reply. I realise that running this locally will make a huge difference to performance, but I am building this for someone else who will need to run this process each quarter and don't want them to have to keep copying the database backwards and forwards. I will post a copy...

The 450k records are all new, they are in relation to the past quarter. They get summarised and then appended to history tables. This takes place each quarter in order to give a full historical picture of how the numbers are developing. The history tables are used for numerous reporting and...

The trouble is that I am trying to automate as much of this as possible as I will be leaving this job in a few months and someone else will need to maintain the database. Without an in-depth knowledge of the database they will not be able to do this (copy to local drive). Also access to the...

The problem is that the append query needs ALL of the data in this table. It is all current data and is used to produce summary info that is appended to history tables. However, the process could be broken down into several stages by filtering out date ranges. I could write the date ranges to...

I have a table containing 450,000 records (yes I know it's probably pushing the limits for Access) and need to perform an operation to summarise certain records and append them to another table, containing about 2,000-3,000 records. Not surpirisingly it takes quite a while (5 hours in fact). I...

Pat, OK, but if your action query needs to be programatically re-created each time it is run (for example if field names or values need to be dynamically changed) then there is presumably no overhead in using runsql as opposed to saving the querydef and then running it?

Having spent the last 7 years developing Access databases I'm about to take the plunge and try my hand at freelancing. Can anyone give me some idea about how much work there is out there (I'm based in Essex in the UK). If any of you are in the same boat, where do you get your leads from?

Thanks the link is very useful. However, I have another question. What is actually lost through setting the UseTransaction query property to No? If there are no real detrimental effects and this option serves only to improve performance, why is the default "Yes"?

Has anyone used transactions in Access? If so how well do they work in undoing record entries that failed?

They are a large insurer and have their own development team, therefore as you say they SHOULD be able to work things out for themselves. But for some reason they want chapter and verse. I would normally agree with you about giving them my card etc, but I want to keep them happy as they pay...

That is true iro stuff that I do for private clients, but when I am contracting (working on site) it's a little different as the firm I am working for now want to support the database themselves once my job is done. Therefore I need to leave them enough to fathom out how the things hangs...

The best way is to use a form. Open it when you start your updating, then close it when finished.

In the past the documentation I have provided for any database I have built has consisted basically of detailed user instructions and the Access Documenter output for all tables, form, queries etc. As I work on my own it is difficult to know whether this is the norm or whether something further...

What I want is a reference that I can use BEFORE I come to this and other forums and start searching the web for answers. Although the help and advice I have received through this forum in the past has been excellent, time is money and I do not always have the time to mooch about on the web...

Basically I'm looking for a library of code snippets, functions and add-ins that I can use as a reference rather than having to hunt around for stuff. The kind of things I'm after would be, for example, code to open a 'save as' or 'file open' dialogue or an auto compacting routine or code for a...

Can anyone recommend a good FREE source for Access code and add-ins?

Thanks for the explanation, I think I need a wet towel to wrap around my head now!! How on earth did you work that out?