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

Helge <(E-Mail Removed)> wrote in
news:77fe78b5-0de5-4d5b-816f-(E-Mail Removed)
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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

On 19 Jul., 20:44, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> Helge <helge.klungl...@plena.no> wrote innews:77fe78b5-0de5-4d5b-816f-(E-Mail Removed)
> 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.
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> usenet at dfenton dot com * *http://www.dfenton.com/DFA/

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?

Helge <(E-Mail Removed)> wrote in
news:d153cb72-349a-4d0a-8123-(E-Mail Removed)
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?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

On 20 Jul., 18:57, "David W. Fenton" <XXXuse...@dfenton.com.invalid>
wrote:
> Helge <helge.klungl...@plena.no> wrote innews:d153cb72-349a-4d0a-8123-(E-Mail Removed)
> 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?
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> usenet at dfenton dot com * *http://www.dfenton.com/DFA/

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?

Helge <(E-Mail Removed)> wrote in
news:88c8a392-836e-4c95-a976-(E-Mail Removed)
m:

> On 20 Jul., 18:57, "David W. Fenton"
> <XXXuse...@dfenton.com.invalid> wrote:
>> Helge <helge.klungl...@plena.no> wrote
>> innews:d153cb72-349a-4d0a-8123-56c
> (E-Mail Removed)
>> 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?
>
> 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.

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

On Jul 24, 10:58*pm, "David W. Fenton" <NoEm...@SeeSignature.invalid>
wrote:
> Helge <helge.klungl...@plena.no> wrote innews:88c8a392-836e-4c95-a976-(E-Mail Removed)
> m:
>
>
>
>
>
> > On 20 Jul., 18:57, "David W. Fenton"
> > <XXXuse...@dfenton.com.invalid> wrote:
> >> Helge <helge.klungl...@plena.no> wrote
> >> innews:d153cb72-349a-4d0a-8123-56c
> > 11496b...@u26g2000yqu.googlegroups.co
> >> 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?
>
> > 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.
>
> --
> 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).

Helge <(E-Mail Removed)> wrote in
news:669e3641-2d8a-4846-a160-(E-Mail Removed)
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.

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

On Jul 25, 7:35*pm, "David W. Fenton" <NoEm...@SeeSignature.invalid>
wrote:
> Helge <helge.klungl...@plena.no> wrote innews:669e3641-2d8a-4846-a160-(E-Mail Removed)
> 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.
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> contact via website only * *http://www.dfenton.com/DFA/

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

Helge

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




On Jul 19, 8:00*am, Helge <helge.klungl...@plena.no> wrote:
> 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