Solved

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

Posted on 2013-06-07
3
470 Views
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.
0
Comment
Question by:jegajothy
3 Comments
 
LVL 69

Assisted Solution

by:Merete
Merete earned 250 total points
Comment Utility
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?
Cheers
Merete
0
 
LVL 20

Accepted Solution

by:
GrahamMandeno earned 250 total points
Comment Utility
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]
0
 

Author Closing Comment

by:jegajothy
Comment Utility
Excellent solutions for the project.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly‚ÄĒanytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

PaperPort 14.5 Patch 1 update is often not detected or downloaded automatically. This article provides direct download links to solve the problem for retail (non-bundled) versions of the Standard and Professional editions, as well as the Professiona…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
The goal of the tutorial is to teach the user how to use the cropping tool and to straighten there photos so it does not look tilted. You will choose which photo you want to edit, crop it to you liking and make it straight.
The goal of the tutorial is to teach the user how to use import presets downloaded from the internet into Adobe Lightroom. Once you downloaded the presets go into the preset folder and press import then import your preset and your set it to go.

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now