Linking external files ?

[maverick]

Just want to ask people...

What does everyone think is the best way to link external files like (*.tif) images ?

HyperLinks or OLE objects ?????

Any Ideas ...

Thanks,
Maverick "Hacker by Heart"
saenzinc@email.com

 

[Aivars]

Hi!
HyperLinks as well as OLE objects.

Aivars

 

[maverick]

SOLUTION:

I have figured out that "Hyperlinks" are the best way to link files of any type to a DB record, with the help of DougP I was able to link and open files linked to a record by using a the CommonDialogBox...

Thanks to all Involved!
if anyone would like a demo of this email me...

"Hacker by Heart"
saenzinc@email.com

 

[Francescina]

The main problem of using OLE is the bloating effect. In most cases only the path and filename is stored in the table, but this leads to administration problems once you have a certain quantity of graphic files.
An alternative to the ACCESS OLE server is the Graphics Wizard (Powerups page at

http://www.unsoftwareag.com)

that avoids the bloating effect and provides supplementary functions.

 

[maverick]

I agree about OLE,
usually crashes at about 1250 links...

But !
My solution does not use OLE, "Old Limited Embedding" he he

this works great and is only limited by access record limitations, so if you have billions of records make it SQL, with an Access Front-End...
works great

"Hacker by Heart"
saenzinc@email.com