Database with lots of pictures

[Helge]

What is the best way to make a database with lots of large pictures
thats allready on my machine?

Using hyperlinks to the file on the machine?
- How can I make queries and open the hyperlink?

Save the file in the Accessdatabase as an attachmenttype?
- Will the Accessdatabase be to big when I have many large pictures
saved?

Hope any have some good tips.

Helge

 

[David W. Fenton]

m:

What is the best way to make a database with lots of large
pictures thats allready on my machine?

Using hyperlinks to the file on the machine?
- How can I make queries and open the hyperlink?

Save the file in the Accessdatabase as an attachmenttype?
- Will the Accessdatabase be to big when I have many large
pictures saved?

Hope any have some good tips.

I would use neither of these. I'd use a text field to store the path
and another to store the filename. If you're storing all the files
in the same location, then you can skip the path field.

For opening them with a doubleclick, you can use a doubleclick event
handler on your form to open them with Application.FollowHyperlink.

In general, I'd avoid hyperlink fields because they are hard to deal
with, and I'd never use attachment fields because they are
multi-value fields and that should be used only for compatibility
with Sharepoint (which is the whole reason the data type was added
to Access).

For more details, just ask.

 

[Helge]

I would use neither of these. I'd use a text field to store the path
and another to store the filename. If you're storing all the files
in the same location, then you can skip the path field.

For opening them with a doubleclick, you can use a doubleclick event
handler on your form to open them with Application.FollowHyperlink.

In general, I'd avoid hyperlink fields because they are hard to deal
with, and I'd never use attachment fields because they are
multi-value fields and that should be used only for compatibility
with Sharepoint (which is the whole reason the data type was added
to Access).

For more details, just ask.

Thank you so much.

What if I want to make a query from Excel using ODBC. Would you make
macro in Excel converting path and filename to a hyperlink?

 

[David W. Fenton]

m:

What if I want to make a query from Excel using ODBC. Would you
make macro in Excel converting path and filename to a hyperlink?

Why do you need a hyperlink?

 

[Helge]

Why do you need a hyperlink?

Because I want to open the file and se the picture from Excel. I just
have the path as a text in the tabel in Excel. I thougt I had to
convert it to a hyperlink by using a macro. Do you have any other ways
to do it?

 

[David W. Fenton]

m:

Because I want to open the file and se the picture from Excel. I
just have the path as a text in the tabel in Excel. I thougt I had
to convert it to a hyperlink by using a macro. Do you have any
other ways to do it?

I've completely lost the context of where you're actually executing
the code, whether in Access or in Excel.

The Access/Jet/ACE hyperlink field type saves you almost no work and
leads to tons of problems because it displays one thing and stores
something completely different. You can store the same information
without using hyperlink field type and write a tiny amount of code
to execute it and not have the problems associated with hyperlink
fields.

 

[Helge]

m:







I've completely lost the context of where you're actually executing
the code, whether in Access or in Excel.

The Access/Jet/ACE hyperlink field type saves you almost no work and
leads to tons of problems because it displays one thing and stores
something completely different. You can store the same information
without using hyperlink field type and write a tiny amount of code
to execute it and not have the problems associated with hyperlink
fields.

--
David W. Fenton                  http://www.dfenton.com/
contact via website only    http://www.dfenton.com/DFA/- Hide quoted text -

- Show quoted text -

The code and database is in Access. It was very smart not using a
hyperlink and instead using the dobbelclick-event to open the file in
Access. What I was thinking is: If I want to take out pictures from a
certain category and show a list of those pictures in Excel (using
ODBC). Then I would get the list with path and filename saved in one
column. If I want to open one of the records (pictures) I thougt that
converting path and filename to a hyperlink would be the smartest way
to do it (in Excel).

 

[David W. Fenton]

m:

The code and database is in Access. It was very smart not using a
hyperlink and instead using the dobbelclick-event to open the file
in Access. What I was thinking is: If I want to take out pictures
from a certain category and show a list of those pictures in Excel
(using ODBC). Then I would get the list with path and filename
saved in one column. If I want to open one of the records
(pictures) I thougt that converting path and filename to a
hyperlink would be the smartest way to do it (in Excel).

I don't program in Excel, so can't say. If Excel has a hyperlink
data type, then I suppose you can use it, but you'll have to look at
the Excel documentation to figure out how to format it
appropriately.

 

[Helge]

I don't program in Excel, so can't say. If Excel has a hyperlink
data type, then I suppose you can use it, but you'll have to look at
the Excel documentation to figure out how to format it
appropriately.

You have helped me a lot so far. Thank you so much. I might go for a
solution without using Excel.

Helge

 

[a a r o n . k e m p f]

SQL Server has a couple of different ways to store images.. one of
them is by using something called FileStream.. using this method, you
get all the benefits of using the image datatypes (image, varbinary,
varbinary(max), etc)
but you can still keep the file in a folder and there isn't any of the
bloat associated with using Jet to do this