Locking problems when attaching files in a form

  • Thread starter Thread starter Arne Olsson
  • Start date Start date
A

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
 
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...
 
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
 
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
 
Back
Top