Corruption in Access 2k3 databases

am 05.02.2007 02:15:58 von Jack Black

I seem to notice that Access 2k3 tables tend to get corrupted rather easily
when running as a database back-end for ASP applications (different
providers, different code, same structure and content corruption).

Are there any general practices that can prevent this corruption? I don't
have server access at the providers to install MDAC updates and such, so
what's the average developer with public websites to do?

Thanks!
Jack

Re: Corruption in Access 2k3 databases

am 05.02.2007 09:10:51 von Mike Brind

"Jack Black" wrote in message
news:u$7isMMSHHA.1600@TK2MSFTNGP05.phx.gbl...
>I seem to notice that Access 2k3 tables tend to get corrupted rather easily
>when running as a database back-end for ASP applications (different
>providers, different code, same structure and content corruption).
>
> Are there any general practices that can prevent this corruption? I
> don't have server access at the providers to install MDAC updates and
> such, so what's the average developer with public websites to do?
>

Use Sql Server 2005 Express Edition instead. If your current host doesn't
support it, there are plenty around that do.

You can delay the inevitable [corruption in Access] somewhat by following
the advice given here: http://support.microsoft.com/default.aspx/kb/303528

However, if your database is primarily there to serve up data, and not
perform UPDATES or INSERTS, you may find that an Access database will go for
years trouble-free.

--
Mike Brind

Re: Corruption in Access 2k3 databases

am 05.02.2007 19:50:43 von mmcginty