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

Anonymous

2023-07-14T23:24:27+00:00
OK; we do have them in a text file. Ichthyologist calls it NE.txt and it is in the same directory as his small access table with the same images.directory . I guess it would be easier to say that everything we are doing is in the same folder.

He has three different files, A txt file named NE.txt, One Access Table with a column of the name of the samples and an mdb we are trying to get working with the current code, most of what you sent us.

Here is the code I am playing with at this moment:

Dim dbb As DAO.Database
```
            Dim rst As DAO.Recordset  

            Dim strFile As String  
              
            Set dbb = CurrentDb  
              
            Set rst = dbb.OpenRecordset("Select PctrJPG From MstrPhts")  
              
            strFile = "C:\NEPhotos\"  
              
            Do Until rst.EOF  
              
                strFile = strFile & rst!PctrJpg              '  All of the image names are followed with.jpg  
              
                MsgBox Me.Picture = strFile             '    trying to view image  
                  
                rst.MoveNext  
              
            Loop  
```
He had to go to the hospital and look at some slides.

He has been pretty happy that he is starting to see some results.

We want to try to finish up, we have to be in Knoxville next Monday night.

DHookum, you have been great
Was this answer helpful?

0 comments No comments
Anonymous

2023-07-14T23:52:48+00:00

The community told us we do not need ODBC for the application; We were having trouble understanding data from inside and ourside the database.

DHookum sent us some code I am messing with right now, Once we can display the images, We will have only one step to go.

In a way what we are close to getting will be something the pathologists can look at and maybe they will look at it and go from here.

Thanks; This is my first experience working inside of .mdb and text files.

Old NASA Kid
Was this answer helpful?

0 comments No comments