Microsoft Access 2003 Hyperlinks

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

Guest

I have created a database for resumes for our recruiting company. I am
linking each resume to the record via a hyperlink to a word document, however
the hyperlinks have been painfully slow. I have experimented with
subdirectories (one for each state) to limit the number of docs in each
folder, but it has not helped the upload speed.
 
jharting said:
I have created a database for resumes for our recruiting company. I am
linking each resume to the record via a hyperlink to a word document,
however
the hyperlinks have been painfully slow. I have experimented with
subdirectories (one for each state) to limit the number of docs in each
folder, but it has not helped the upload speed.
Click to expand...

Instead of using a hyperlink, try using ShellExecute to start an app with
it's associated program. Not only should it be faster, but you can store a
simple path as a text file thereby reducing both size and the possibility of
corrupting a row of data in a power outage.

http://www.mvps.org/access/api/api0018.htm
 
I've started looking at the Shellexecute command you were speaking of, but I
am very unfamiliar with it. Could you just give some very basic beginning
help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink 1
Data Access Page Hyperlinks 1
Type mismatch error - Setting Hyperlink Base property 2
MS Access 03 links, hyperlinks and headaches! 1
Store the full path and document name in a hyperlink 1
Hyperlink field that does not link to the file 3
Create a Hyperlink Automatically 1
Create a hyperlink in Access Table to Word Doc 2007 2

Back
Top