How Do I Make Sense of Microsoft Access?

Posted by ryuzaki0 on Friday August 11, 2006 @02:30PM from the access-denied dept.

Anthony Boyd asks: "I have a pretty good tool-set for LAMP work, but as I get into Microsoft jobs, I've started to wonder if I'm working with the best tools. In particular, I'm exploring an 'out of control' Microsoft Access setup, which has about 200 tables in 30 .mdb files, including some duplicated/outdated tables. I'd like to print the properties of each table (with the comments for each field), print the table list for each database, get info on the field types & relationships, and so forth. What tools do you suggest for trying to grok a large Access mess?"

1 of 100 comments (clear)

Min score:

Reason:

Sort:

It is being misused by PhrostyMcByte · 2006-08-11 15:02 · Score: 4, Insightful

If you have that many access databases, you are probably misusing it. Import all that data into SQL Server, and start from there. There is no magic way to make sense of a database schema.. the best you'll do is grabbing a GUI that visualizes it.