Hyperlinks - merging a paper doc database with file manager and outlook mail

From: airy (airy.magnien_at_nooospam.libertysurf.fr)
Date: 12/20/03 

Date: Sat, 20 Dec 2003 10:25:24 +0100

Hi,

I'm using D7A, W2k, and Bold.

In my office, we are *very* slowly moving to the paperless state,
essentially because paper just has too many advantages and only one big
drawback (too few cupboards).

So the transition will be very long (15 years at least) and I wish to
make an integrated database for paper, files, and e-mail. Since our
bosses have already achieved the secretaryless office, it becomes urgent.

1st step (done) was to organize paper, files and e-mail according to a
single "sorting tree" : a folder tree for the files, and a database
accessed through a treeview for paper stuff.

As a 2nd step, I wish to add (to the database) links to files situated
on a network drive. Where a paper doc record has a physical location
stored in a field (cupboard #n, shelf #m, etc.), a file would have a
hyperlink stored, so clicking on it would open the file.

The 3rd step (e-mail integration) is kept for later, but must be kept in
mind because I will need an integrated solution in the end.

What do you think is the simplest way to handle hyperlinks of that kind?

I haven't found such kind of class in the VCL.

Grateful for any hints

Airy

Relevant Pages

  • Re: Another view on analysis and ER
    ... And the need for integration ... My vision of database design is biased towards considering this the central ... Normalization is really only a very minor issue here IMO. ...
    (comp.databases.theory)
  • Re: SQL Server and VSS
    ... The main problem with a full integration is that there is no way to mark an ... object as checked out, or read only, in a database. ... > integrates SQL Server and VSS. ... > Microsoft plan to have SQL server integrated with VSS in the next version? ...
    (microsoft.public.sqlserver.server)
  • Re: What is Pick anyway?
    ... and maintained by separate teams of programmers. ... > finer details than a combination of database constraints and SQL ... It's useful to think about the data model as distinct from the programming ... >> how I'd apply the same model to enterprise wide data integration. ...
    (comp.databases.theory)
  • Re: VB6, IDE, SourceSafe integration
    ... It is time consuming, because my SS database ... Local Files Tab ... There are even more options if you run SourceSafe as a standalone app... ... quite a few people turn SS integration off in VB's IDE ...
    (microsoft.public.vb.general.discussion)