Problem with Access 2003 and Adobe 8.0

[soccerelf]

I created a database that the office uses to manage ongoing projects. In
addition, I use the hyperlink feature which allows the user to access the
project folder which resides on the network. However, when I have the
database open, I am unable to open any Adobe file. As soon as I close Access
I am able to open the document. I am trying to find out if there is a way
around this problem. I am not too familiar with coding, but any ideas or
suggestions on how to deal with this problem is appreciated.

 

[aaron.kempf]

You need to give us more information.

What type of documents are you talking about?
Is Access 'busy doing something' when you're having these troubles?

--------------
In general-- Access is a resource hog. More importantly; it clogs up
some of the plumbing in Windows (how else to explain that double-
clicking on a secondary MDB file doesn't open it-- because Windows is
clogged up with the first instance).

So.. Instead of double-clicking on a PSD file.. Can you open photoshop
and then go file, open and select the PSD that way?
--------------
Whenever I have a problem-- and Access isn't opening.. I start up
another instance of MS Access and then go file, Open to get to that
file.

The alternative to doing this-- is putting a shortcut to MSACCESS in
your sendto directory. Then you can do it with a single right click
instead of going through the hassle of opening another instance of
Access and then opening.

I'm proposing that this resolution might help you- in a similiar
fashion.

Again-- sometimes if you double-click an Access file and it doesn't
open (Because Access is 'busy') then you can just right click sendto
MS Access and it will open instantly.

I believe that you might have the same problem that I am diagnosing.

In general-- Access is a resource hog. More importantly; it clogs up
some of the plumbing in Windows (how else to explain that double-
clicking on a secondary MDB file doesn't open it-- because Windows is
clogged up with the first instance).

So.. Instead of double-clicking on a PSD file.. Can you open photoshop
and then go file, open and open the PSD that way?

If that works-- then put a shortcut to photoshop in your sendto
directory.. And when Access is tying up your machine; right click send
to and it should work like a charm.

-Aaron

 

[Gina Whipp]

Without seeing exactly how you are using the hyperlink feature I suggest:
FollowHyperlink FilePath & "\" & FileName

It should open the .pdf as long as Acrobat Reader is installed on the
machine.

 

[soccerelf]

The hyperlink should be something like
\\Shared-drive\officename\state\project and the file that I am connecting to
is on a shared network.

However, when I select the hyperlink it will open the file as
\\Shared-drive\officename/state/project

If I try to open a pdf my CUP Usage reaches 100%. As soon as I change the
direction of the / to \ I am able to open the pdf.

Is there a way to format the structure for a hyperlink?

Please let me know if this provides the information you are looking for.
Again, thank you for assistance this.

 

[Gina Whipp]

This is correct:

\\Shared-drive\officename\state\project\NameOfFile.pdf

When you change it to a backslash does your CPU still reach 100%? When you
say a way to format it not sure what you are asking... do you mean
dynamically? You can do that by placing this on double-click

\\Shared-drive\officename\state\project & "\" &
[NameOfTheFieldThatContainsTheFileName]

 

[Gina Whipp]

I just noticed... watch out for line wrapping... It should be all on one
line!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

This is correct:

\\Shared-drive\officename\state\project\NameOfFile.pdf

When you change it to a backslash does your CPU still reach 100%? When
you say a way to format it not sure what you are asking... do you mean
dynamically? You can do that by placing this on double-click

\\Shared-drive\officename\state\project & "\" &
[NameOfTheFieldThatContainsTheFileName]
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

The hyperlink should be something like
\\Shared-drive\officename\state\project and the file that I am
connecting to
is on a shared network.

However, when I select the hyperlink it will open the file as
\\Shared-drive\officename/state/project

If I try to open a pdf my CUP Usage reaches 100%. As soon as I change
the
direction of the / to \ I am able to open the pdf.

Is there a way to format the structure for a hyperlink?

Please let me know if this provides the information you are looking for.
Again, thank you for assistance this.