Locking problems when attaching files in a form

[Arne Olsson]

Hi!
I,ve built a small application with access 2007 and in one form it is
possible to attach files. When working from onePc this works fine but when
testing to attach files from two Pc,s at the same time it locks the system.
Is it possible to fix this problem in some way?
Best regards
Arne Olsson

 

[Piet Linden]

Hi!
I,ve built a small application with access 2007 and in one form it is
possible to attach files. When working from onePc this works fine but when
testing to attach files from two Pc,s at the same time it locks the system.
Is it possible to fix this problem in some way?
Best regards
Arne Olsson

If I were you, I would use the OpenSaveFile API, and then just store
the path to the file...

 

[Arne Olsson]

Hi!
Would that work if the enduser have the file on their laptop, and how to
see the file if the end user turns of the laptop?
Best regards
Arne

 

[Bob Quintal]

Hi!
Would that work if the enduser have the file on their laptop, and
how to see the file if the end user turns of the laptop?
Best regards
Arne

In my databases, I use the OpenSaveFile API to get the name of the
file, then the filecopy command to create a copy of the file in a
subdirectory of the database back end. I name this copy of the file
with as the primary key of the the row that stores details of the
file and the extension copied from the original file name.
I then use the setAttr() function to make the copy read-only.

Bob