How do I create a link to locate specific file at Local drive?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to manager a Large Database by using Microsoft Access. For example
1000 Document Numbers, and they all have their own drawing at Local Drive
under a Folder. What I'm trying to do is to creat a link or a bottom, so that
whenever I type in the Document Number then click this link or bottom, I can
locate the specific Drawing at Local Drive.Thank you!
 
Hi Jason,

The simplest way is to store the filespecs in a Hyperlink field. E.g.
put
"C:\Folder\Subfolder\Document_0999.dwg"
in a hyperlink field, and when you click in a textbox bound to the field
Access will tell Windows to launch the document.

A slightly better approach is to store the filename and path separately,
so that if it is necessary to change the path it is not necessary to
change all the individual records. (A change in network configuration
could require a change in the path, for example.) In that case you'd
store the filename in a text field in the table, and the path in a
single location elsewhere in the database (e.g. in a "Settings" table
with other configuration information). To open the document, have the
code behind your button concatenate the path and name and pass the
result to Application.Hyperlink.

There's a sample document management database "DocMgr 2k" at
http://www.datastrat.com/datastrat2.html . It's worth looking at.

On Thu, 19 Apr 2007 00:52:03 -0700, Jason Wong <Jason
 
Back
Top