hyperlink

  • Thread starter Thread starter Maggie
  • Start date Start date
M

Maggie

Hello, I'm storing a hyperlink in an Access table which
links to architect drawings that are stored on a server
J:/APS Projects/2002/Buctel/drawings. There are over 100
of these drawings. After 2 years these drawings are moved
to a folder called "Archive". How do I quickly change the
path that is stored in the table from
J:/APS Projects/2002/Buctel/drawings to
R:/Archive/2002/Buctel/drawings without changing each
individual record?

Or is there a different way to do this that is more
efficient? Thanks Maggie
 
UPDATE MyTable SET ArcDrawingsPath = "R:/Archive/2002/Buctel/drawings"
WHERE DrawingIssueDate > Date() + 365*2

Pavel
 
Back
Top