Access 2007 - database of wires, cables, switches, etc.

Posted on 2013-06-07
Medium Priority
Last Modified: 2013-06-08
My OS is win 7 Prof 64 bit and I use Access 2007.  I am trying to create an Access 2007 database of an inventory of all my wires, cables, switches, plugs, thus I will know what I have and not run off to the store to buy one.
The problem is identifying with a graphics picture of what both ends of a wire or cable look like.  Eg., we know how both ends of a pc power cable looks like, or I know how a printer parallel cable looks like, and also by what names they are labeled or called as.
is there any resource of each item of cables, wires, switches, or plugs look like , i.e. how both ends look like, so that I could use this in my database that I am attempting to create.
Or if there a readily available database or something similar to my idea, that I could use or build upon.  Thank u.
Question by:jegajothy
LVL 70

Assisted Solution

Merete earned 1000 total points
ID: 39231051
Hi, with some difficulty but there is schematics of your motherboard.
I fully understand and agree with what your trying to achieve, if I may suggest google your motherboard and then click on images
like this, having the accurate identification will help with looking for an image of that plug/switch etc
Motherboard switched plugs

Computer Cable Identification Field Guide

Does that help?
LVL 20

Accepted Solution

GrahamMandeno earned 1000 total points
ID: 39231053
There are several ways to associate a picture with a record in an Access database.

1. You can embed the image in an OLE Object field (not recommended because it has no data compression and causes database bloat).

2. You can store the image file in a known folder, and store its file name in a text field in your record.

3. In Access 2007 or later you can store one or more images in an Attachment field.

With any of these methods, you can load the picture into an image control to display it in a form or report.

It is difficult to provide more detail without knowing more about your database structure and requirements.

Best wishes,
Graham Mandeno [Access MVP 1996-2013]

Author Closing Comment

ID: 39231501
Excellent solutions for the project.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Nuance's PaperPort may display this error message: PaperPort appears to be running Windows XP Compatibility Mode which may result in errors. We recommend disabling Compatibility Mode for the PaprPort.exe program, see Technote 6629. This articl…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question