AutoCAD/MS Access Frontends with SQL Backend Integration

AutoCAD/MS Access Frontends with SQL Backend Integration

Problem: Each Sub-Department at the Utilities Department of the University of Colorado at Boulder have specific requirements for spatial and spatial data and often, there is an overlap of information crucial to these sub-departments; operations, maintenance, management,
etc. Equipment data is stored and maintained in an SQL database with a frontend designed in MS Access. All spatial data is stored in vector based (AutoCAD) drawings. Supervisors and management want to use a frontend interface to access and analyzed spatial and spatial data
easily.

Solution: Design, create, implement and maintain a stable application database that can generate queries based on vector and spatial (text, number date) data. All graphical data are linked with attribute (spatial) data which are managed by a RDBMS. A solution needs to be developed using AutoCAD Map as a frontend with an SQL backend.

Result: Increased in cooperation and communication among departments.
Eliminated redundant spatial and aspatial data. Cleaner PID for all different systems of the Co-Generation plant. A substantial reduction of time used to track parts, quipment manufacturer, model, part number.

Enabled access to information across multiple departments apart from bringing in greater efficiency, speedy decision-making and transparency in the functioning.

Similar Posts

54 Comments

  1. Pretty component to content. I simply stumbled upon your blog and in accession capital to claim that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing for your augment or even I fulfillment you access consistently fast.

  2. Thanks for a marvelous posting! I definitely enjoyed reading it, you will be a great author.I will make sure to bookmark your blog and definitely will come back from now on. I want to encourage you to continue your great posts, have a nice day!

  3. Pretty great post. I simply stumbled upon your blog and wanted to mention that I have really enjoyed browsing your blog posts. In any case I’ll be subscribing on your feed and I am hoping you write again soon!

  4. obviously like your web-site however you need to test the spelling on quite a few of your posts. Several of them are rife with spelling problems and I in finding it very bothersome to tell the truth on the other hand I will surely come back again.

  5. I think this is one of the most significant information for me. And i’m glad reading your article. But want to remark on few general things, The website style is great, the articles is really excellent : D. Good job, cheers

  6. I know this if off topic but I’m looking into starting my own blog and was wondering what all is required to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet savvy so I’m not 100% sure. Any recommendations or advice would be greatly appreciated. Cheers

  7. Hey there just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Firefox. I’m not sure if this is a format issue or something to do with web browser compatibility but I thought I’d post to let you know. The layout look great though! Hope you get the problem solved soon. Cheers

  8. Howdy! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My web site looks weird when viewing from my iphone4. I’m trying to find a theme or plugin that might be able to correct this problem. If you have any suggestions, please share. Thank you!

  9. Great goods from you, man. I’ve understand your stuff previous to and you’re just too great. I really like what you’ve acquired here, really like what you’re stating and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I cant wait to read far more from you. This is actually a great website.

  10. Hey there! Would you mind if I share your blog with my twitter group? There’s a lot of people that I think would really enjoy your content. Please let me know. Thanks

  11. Greetings from Carolina! I’m bored to death at work so I decided to check out your website on my iphone during lunch break. I enjoy the info you present here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyhow, superb site!

  12. Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a bit, but other than that, this is great blog. An excellent read. I’ll definitely be back.

  13. An impressive share! I have just forwarded this onto a friend who had been doing a little research on this. And he in fact bought me lunch because I found it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to discuss this topic here on your web page.

  14. Wow, incredible blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your web site is magnificent, let alone the content!

  15. Hello there! I could have sworn I’ve been to this blog before but after going through some of the posts I realized it’s new to me. Anyways, I’m definitely happy I discovered it and I’ll be bookmarking it and checking back regularly!

  16. You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

  17. I love your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to create my own blog and would like to know where u got this from. thank you

  18. I’ve been exploring for a little for any high-quality articles or blog posts in this kind of space . Exploring in Yahoo I eventually stumbled upon this web site. Reading this info So i’m satisfied to express that I have a very just right uncanny feeling I came upon exactly what I needed. I such a lot indisputably will make certain to don?t forget this site and give it a look on a continuing basis.

  19. Unquestionably believe that that you stated. Your favourite justification appeared to be at the internet the simplest thing to bear in mind of. I say to you, I definitely get irked even as other folks consider concerns that they plainly do not recognise about. You controlled to hit the nail upon the top as welland also defined out the whole thing with no need side effect , folks can take a signal. Will likely be back to get more. Thank you

Comments are closed.