Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Tue Sep 7 08:03:09 CDT 2004
Sorry for the late replies...4-day weekend;) As an engineering department, we utilize a plethora of CAD/modeling packages, but the driving force behind using AutoCAD in this instance is that the facilities management department uses AutoCAD and they have graciously bestowed upon me a full-scale floor plan. Currently, the information which I am trying to consolidate, which includes a physical representation of the floor plan, resides in several Excel spreadsheets. Several copies of the worksheets are necessary to cover all the information for office equipment and personnel. Many of these "overlays" include the personnel name data. Each time a minor change occurs in the department, several of these "overlays" must be changed. You can see how my innate sense of normalization was offended at this process;) So, what I proposed was a single normalized database that would store all of the data for personnel and equipment. The AutoCAD drawing could then be updated dynamically as needed...such as when personnel move and we need to update the "You are here" maps that show the cubicle locations for everyone. A secondary reason for using in-house readily available software, is that, when complete, this combined Access/AutoCAD application will be submitted as an "Opportunity For Improvement" to hopefully be utilized throughout the enterprise. Mark -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Saturday, September 04, 2004 12:59 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Access & AutoCAD Hi Mark: Sorry I am late to this conversation but is not AutoCAD comprised of a group of exposed objects (dlls and ActiveX components) and AutoLISP, a VBA type language. You of course have to be on a station where AutoCAD is installed as well as Access. One friend works in a government mapping office that uses ArcInfo but has a number of translators and automated translation processes, one script used translates AutoCAD DWG files into ArcInfo files and back...all using various built in objects and their properties. I know they have the capabilities to automate the extraction by levels, object types etc.. I imagine anything else would be possible. I think there is a few downloads and samples from some of the companies that work extensively with various government agencies like: http://www.esri.com/. I might be able to get some help but would have to know a specific requirement. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Thursday, September 02, 2004 12:51 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Access & AutoCAD Both. First project is our departmental floor plan which will include ALL of the attributes for personnel and equipment. Later projects will build BOM drawings in AutoCAD dynamically. Concurrently with those, I would like to develop an automation process which monitors a network folder, and when a new drawing is placed there, automatically extract certain drawing attributes, log them into a database, and create a .dwf format version for intranet publication. Mark -----Original Message----- From: John Bartow [mailto:john at winhaven.net] Sent: Thursday, September 02, 2004 1:30 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Access & AutoCAD Mark, Are you trying to use automation between the two or are you trying to use access as a database for Autocad Attributes? John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark S. (Newport News) Sent: Thursday, September 02, 2004 12:04 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Access & AutoCAD ...so I'm guessing I'm the only one in this unique position:((( Mark -----Original Message----- From: Mitsules, Mark Sent: Wednesday, September 01, 2004 5:42 PM To: [AccessD] Subject: [AccessD] Access & AutoCAD Has anyone tackled this combination? There is ONE example in the AutoCAD samples folder. There is ONE book that I found regarding database connectivity (circa 1999). ...and a DISTINCT lack of web-based material as far as I can tell:( I would be most appreciative for pointers towards any of the following: recent books (AutoCAD 2002 or later), web-based tutorials, web-based examples, personal examples, cave paintings...anything. Thanks in advance for any/all information. Mark Conversely, I am willing to pay $40 to anyone willing to take the AutoCAD help files and develop a booklet within the next 2 weeks, including a table of contents, that will allow me to chronologically work my way through a project. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com