Microsoft Access

[stampman]

I currently use Access to store data for my machine setup. I can print a report with a Bill of Material, I would like to add an AutoCad drawing for each tool, is this possible?

[svenakela]

Either you save the Autocad drawing on a folder and link it in the Access DB, or you can store it as a binary object inside the database. But as you have to create the drawing, and save it in a folder, I would go for the first option.

--S

[samco]

I made a die database to keep track of our steel rule dies about jeeze - 8 years ago... They where drawn in acad for the laser cutter. I link to that file (creating the file path from the file name) and look for the drawing on the server. I used dwgx 2.01 for autodesk view which is a activeX pluggin. You would have to see what is current and what would work with your version of acad. You could also have acad open by creating the file name and calling it I suppose. I just liked the idea of it being contained within access. They are still using it today.

[stampman]

Thanks for your advise.
I may try the activeX plugin, but I would really like to be able to print some type of a report for shop use.
I have already used a hyperlink, but all I get is the file path on the report. I think I can generate my report in Excel, and import my data thru Microsoft Query.

Thanks Again.