jet db on linux file server problems

Tech-Archive recommends: Speed Up your PC by fixing your registry



One of my clients moved the backend of the Access app that I wrote for them
onto a Linux server a couple of years ago. I don't know a lot about how they
are handling that since I'm not familiar with Linux. The front end mdb of
course is runnig on all Windows machines. When they first set it up they
were very pleased (and mostly still are). The server runs great and the
speed is much better than what they used to have. But early on in running
things we noticed occasional (every few months or so) corruption that I've
never seen with my clients that run all their Access apps on purely Windows
systems. Records would become corrupt and sometimes indexes would get blown
away which would in turn blow away relationships between some tables. More
recently for some reason the entire backend mdb got fried. Fortunately they
are diligent about doing backups and installed one from the day before.

I've done a little bit of hunting on line to see if there's a common problem
out there when using Access and Linux and what the solution might be but I'm
not getting very many results. Has anyone experienced this and if so is
there a good solution? (other than changing from Linux to Windows which
they're not going to do).

Thanks in advance,

Keith


.



Relevant Pages

  • Re: Still have problem with DNS forwarding
    ... >The Linux server is set up as a proxy/DNS so all traffic ... >You have two nics in the sbs box for a reason ... >>>What do you have as the DNS address on them?? ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: WIMP programming under RISC OS and Windows
    ... MacOS and Linux programs from the same source code. ... library was used to port Xara Xtreme to Linux. ... that if I do not plan a full RISC OS backend but add only those SWIs I ...
    (comp.sys.acorn.programmer)
  • Re: Delphi and the .Net platform
    ... reasonable .NET story for Delphi. ... IMO, I wouldn't mess with Lazarus, but I would leverage FPC. ... OSX Client and Linux Server. ...
    (borland.public.delphi.non-technical)
  • Re: Whats the big deal with cross-platform?
    ... C++ Builder as a comfortable debugger and IDE for Linux Server apps, ... A user needs an incentive to switch, a good working C++ IDE for Server-Apps could be that incentive. ...
    (borland.public.delphi.non-technical)
  • Re: Free anti-spam software (was Re: Who should run a mail server?)
    ... >Your product does sound nice for small companies with little Linux ... but of course one can setup a Linux server. ... must also install the mailserver software, anti spam filter, configure ... the energy point is not only a cost saving issue. ...
    (comp.mail.misc)