It's possible that one (or more) of your users have a flaky NIC on their
computer. Access is extremely sensitive to network problems.
You might take a look at what Tony Toews has at
http://www.granite.ab.ca/access/corruptmdbs.htm to see if it can help you
pinpoint the cause.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Bob Z" <sstorme[ at ]comcast.net> wrote in message
news:D4KdnYKijauGUp_YnZ2dnUVZ_sKdnZ2d[ at ]comcast.com...
[Quoted Text] > We are using Win2000 with Access 2002.
> Hopefull I used the correct FE/BE setup.
> The only table resides on a constant network "K" drive.
> This is a linked table.
> I created an MDE file and put it on the 10 users "C" drive.
> After a very short while of use, the data becomes corrupted. This happens
> over and over for the past week.
> I salvage what I can, make some changes, and redeploy.
> The messages are, "not a valid file", "record locked by other user", etc.
> I set it up as shared with record lock. No security.
> Can it be refresh intervals? Help.
> Thanks Bob
>
>
|