I want to do this the easy way but I don't know how.
October 25, 2011 8:55 AM Subscribe
How do I efficiently pull this data from an Access 2003 database.
posted by VTX to computers & internet (6 answers total) 2 users marked this as a favorite
I have a 90mb database in an .MDE format made with Access 2003. It contains hundreds of tables, queries, and forms. I have been tasked with collecting a bunch of information on a specific set of accounts.
There is a main switchboard that will let me search by account number and then take me to another switchboard that will let me view some forms (I think they are forms anyway) specific to that account.
What I've been instructed to do is to view each individual form and then print that to a PDF in a folder for that specific account. I have a list of some 450 accounts on an excel spreadsheet that I need to do this for. I end up with around 30 files per account and this whole project will take me about a month if I have to keep doing this this way.
Since this data is going to a party outside of the company I can't just send them a copy of the full database since it has personal customer information that they aren't authorized to access.
I would like to do one of the two following things:
1. In a perfect world, I would simply delete all of the records except for the ones that are relevant to my 450 accounts.
2. In a slightly less perfect world, I would have a report that would use the account numbers from my excel spreadsheet and then spit out what I need in something readable with one file per account number.
My problem is that I don't have anything but the most basic of knowledge of Access.
I might be able to get a copy of the .MDB version of the database and I might be able to find someone with the database knowledge to actually do this stuff but I need to be able to make a compelling case for it.
My questions are: Are either #1 or #2 possible? Is there some third option I should be considering? How much of an expert do I need to find to be able to do this? How long would it take them to figure it out and make it work?