My company has machines that create an individual database for each machine which can be accessed over a network. The databases are in MS Access. We now have a large number of machines at one customer which makes the data collection into one "summary" form very time consuming.

We are wanting to automate this process. (Currently I have to open each database and then summarize each machine's database manually.) I have been elected (or maybe I volunteered) to create this. The company has agreed to pay for the necessary training in order for me to do this correctly. I have self-taught myself (who else?) Access to the point I can create databases, run queries, etc, (basic stuff).

I am think Visual Basic will give me the capabilities to create what I need but I thought I would check around first before I spend the companies money on my training.

Any thoughts?