Re^2: Lock on file

Thanks, it now works.
From your inputs it sounds like I should not use any kind of Flock and just do the copy?

If I was copying a small Access database the Flock would be needed? And if so what kind?

Comment on Re^2: Lock on file

Replies are listed 'Best First'.
Re^3: Lock on file by Fletch (Bishop) on Feb 10, 2006 at 16:38 UTC
It's highly unlikely Access is going to honor `flock`, but you're definitely welcome to try. And if it doesn't then you don't really gain anything by trying to lock it as it's free to ignore it, hence "advisory locking". Think of it as a "Wet Paint" sign on a bench. The sign itself just tells you, "Hey, sit here and you're going to get covered in paint." You're not prevented from sitting and getting paint on your tuckus, but if you ignore the advisory bad things can happen. Access, more than likely, is going to blithely sit on your freshly painted bench.	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: Lock on file
by Fletch (Bishop) on Feb 10, 2006 at 16:38 UTC

It's highly unlikely Access is going to honor flock, but you're definitely welcome to try. And if it doesn't then you don't really gain anything by trying to lock it as it's free to ignore it, hence "advisory locking".

Think of it as a "Wet Paint" sign on a bench. The sign itself just tells you, "Hey, sit here and you're going to get covered in paint." You're not prevented from sitting and getting paint on your tuckus, but if you ignore the advisory bad things can happen. Access, more than likely, is going to blithely sit on your freshly painted bench.

[reply]
[d/l]