Forum Discussion
prigby
May 06, 2022Copper Contributor
Losing data when sharing a file
An MS ACCESS file is being shared between myself and another party on a network via uploading and downloading. I have been using this upload/download procedure with 2 other ACCESS database files, (di...
arnel_gp
May 06, 2022Steel Contributor
if you close the db while it is uploading/downloading data, truely that is the cause of the problem.
is the transfer over local/premise network?
if so, you can google "Persistent Connection on MS Access", so you can make the transfer a little bit faster.
Next you must add a guard to your upload/download process to validate the user action of closing the db, while the process is on going.
you can create a simple Notification form, that states the Status of the "Critical" process, thereby discourage users from closing the db.
is the transfer over local/premise network?
if so, you can google "Persistent Connection on MS Access", so you can make the transfer a little bit faster.
Next you must add a guard to your upload/download process to validate the user action of closing the db, while the process is on going.
you can create a simple Notification form, that states the Status of the "Critical" process, thereby discourage users from closing the db.