Query getting slower because of pciture in data set

[carremax]

Hello everybody,



I use an access database with picture inside data set. This database became bigger and now a queries last few seconds. The problem comes from the picture. I’d like that Access does not “treat” the picture during query but only when the data set is open by the user. I need a kind of pointer on these pictures.

Has someone a solution for me?

Thanks in advance for your help

[orange]

I think you post is unclear. What data set? What query? Can you tell us WHAT you are trying to do? --simple terms or an example would help.
Sounds like you are currently storing a picture(s) in your database. And you would like to change that.

You can have your "pictures" stored in the windows file system eg. C:\myFolder\MyPictures\PictureId.jpg

And record the location in your table.

[Rawb]

I'd recommend the same thing orange does: Save the picture to the file system and just save the path in your database.

If you need the picture imbedded in the database for some reason, though, you can do this:

• Create a new Table with only two Fields: An autonumber field (the Primary Key), and a Field for the image.
• Change your current Table(s) so that it saves the autonumber value from your image table instead of the image itself. And, whenever you need to use the image, just use a JOIN on the two Tables.

This method has two advantages: First, you're not forced to access the images unless you want to (when viewing the Records from a Bound Form). And second, if multiple Records have the same image, you can just save it in the DB once and point all those Records to the single copy of the image (making the database smaller).