How to build an ODBC Connection

Anonymous

Now that we have a folder with all of the images, How do I connect to it;

Use the query Wizard?

Where do I find the Data Connection Wizzard?

The name of my folder on the C: Drive is NEPhotos

Can I do it with a SQL statement

I have searched around for where and how to do it, but so far got nowhere.

Thanks Again Guys.

Old NASA Kid

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Duane Hookom 26,935 Volunteer Moderator

In all honesty we have never been made aware of project requirements, statement of purpose, scope, number of users, security, how the application needs to be updated and distributed, how data changes will be handled, etc. I have asked but never been answered. How can we get you somewhere when we really have no idea of where you are going. It's like we are in the back seat of a car offering directions without a clear understanding of our final destination. We know full well how to drive and shift and obey traffic laws and navigate but the drive often makes the same mistakes, doesn't seem to hear, plays the radio too loud and doesn't respond. Apparently the driver knows how to drive a tractor in a field but we are in a nearly self-driving car.

I have also suggested several times that based on your need for distributing this application across many locations with limited resources and who knows what age of computer, you should consider a web based application. This would allow for instant updates to all users worldwide, You could restrict access if needed. There would be absolutely no cost to any end user unless you wanted to charge a subscription. Images would be available to all users as long as they had a computer, tablet, or phone connected to the internet. No installing anything anywhere.

If you want to continue down the Access path, please consider creating one new thread with the information I suggested in the first sentence above. Also provide what you currently have which I believe is thousands of images.

0 comments

Answer accepted by question author

Anonymous

I re-vitalized an old form, with two jpg-files:

For future use, you can even enlarge the pictures using the Zoom+ button:

So, in principle it works, but only with a valid file-specification.

Imb.

0 comments

Answer accepted by question author

Anonymous

Me.Image25.Picture = strFile ?????????????

Hi T.Z.,

If strFile contains the full filespecification, including drive and filetype, it should work

Imb.

0 comments

74 additional answers

Duane Hookom 26,935 Reputation points Volunteer Moderator

2023-07-17T02:47:50+00:00
I stated several times the text file must be imported into an Access table. The txt file was only a step to get the names of all the image files to import into a table (or copy and paste). I would expect an Access table with names like:

tblImages

ImageFileName 'name of the image file with either the full drive and path or
```
                                 a file name only with the drive and folder derived from the location of the Access file using CurrentDb.Name
```
ImageSampleName 'What does the image represent?

If this was a table of food the records might look like assuming your drive and folder is constant like folder containing the MDB file:
```
ImageFileName             ImageSampleName

Orange.jpg                Large Orange
GrapeGreen.jpg            Green Grape bunch
GrapeFruitPink.jpg        Pink Grape Fruit
```
There could also be an autonumber primary key.

You should understand how to debug your code.
Was this answer helpful?

0 comments No comments
Anonymous

2023-07-16T17:38:19+00:00
Duane;

Here is the code I copied from you in my computer:

I created an Image Area for my Image, It is Image25

Dim strFile As String

strFile = "C:\NEPhotos"
strFile = Left(strFile, InStrRev(strFile, ""))
strFile = strFile & "NEPhotox\NE.txt"
Me.Image25.Picture = strFile ?????????????

One of my fields contained "C:\NEPhotos\NameofImage

maybe it should have been "C:\NEPhotos\NE.txt\Name of image.

On the above line I get the message---- Microsoft Office can't open the file 'C:\NEPhotos\NE.txt

This is why I tried to put the images in Excel, Which did not work! The file is not open anywhere else.

I also tried to look at it using a Message Box and it only comes up with False.

T. Z. I think has a good idea on the List Box Idea, but I want to get this to work first. He is with me now.

It is telling me that I am on Access 2007 again.

The one nice thing is knowing Assembler is looking for Access07

With all of the hacking going on, it is almost impossible to do anything.
```
                 def = 0

                 str  WorkA

                 str WorkB,'Found at Location'

                 cmt cnt,'Access07' 

                 DS newadr = 8 

                 adr  = def
```
RaG adr = adr +1
```
                 mva = \* + newadr eq    

                 cmp = \*,lgt, 8 

                 ne goto RaG

                 cmmt prtr, WorkB

                 Goto End
```
End lbel *

I ran this program which searches the computer byte by byte'

It found it way out at the end with no indication it was attached to anything. The entire area was used for storing comments.

Probably not a problem, but it is scary

Please try to stick with us, T.Z. appears to be great with Combo Boxes and List Boxes.
Was this answer helpful?

0 comments No comments