Access database maintenance

14 Jan 2006 10:02 PM

VB Programmer

For those that use Microsoft Access as their website's database...

Do you do maintenance on it on a regular basis, such as "Compact and
Repair"?

Do I have to worry about it becoming to big or corrupted?

It's a shopping cart db.

Thanks!

15 Jan 2006 12:02 AM

john smith

VB Programmer wrote:

> For those that use Microsoft Access as their website's database...
>
> Do you do maintenance on it on a regular basis, such as "Compact and
> Repair"?
>
> Do I have to worry about it becoming to big or corrupted?
>
> It's a shopping cart db.
>
> Thanks!
>
>

I don't typically use Access (I dislike and avoid Jet), but I would
definitely make a backup of it before doing the compact and repair
thing. I've seen it break things MANY times before (changing security
settings and things like that). If you have a good amount of data and
that you want some good performance, security and not have all these
issues, you could look into using another DB (like SQL Server Express
which is free).

15 Jan 2006 2:07 AM

Peter Bromberg [C# MVP]

With SQLExpress (SQL Server 2005) being free for the taking, I'd be hard
pressed to come up with a valid reason for even using MS Access on a
webserver anymore.
Conversion is easy.

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com

Show quote

"VB Programmer" wrote:

> For those that use Microsoft Access as their website's database...
>
> Do you do maintenance on it on a regular basis, such as "Compact and
> Repair"?
>
> Do I have to worry about it becoming to big or corrupted?
>
> It's a shopping cart db.
>
> Thanks!
>
>
>

15 Jan 2006 2:44 AM

VB Programmer

Thanks Peter. Going forward I WILL use SQLExpress. I was mostly concerned
with past 1.1 webapps I've created... :)

Show quote

"Peter Bromberg [C# MVP]" <pbromberg@yahoo.nospammin.com> wrote in message
news:FF81A3EE-BCDD-4492-A5C0-97369D5A7E58@microsoft.com...
> With SQLExpress (SQL Server 2005) being free for the taking, I'd be hard
> pressed to come up with a valid reason for even using MS Access on a
> webserver anymore.
> Conversion is easy.
>
> Peter
>
> --
> Co-founder, Eggheadcafe.com developer portal:
> http://www.eggheadcafe.com
> UnBlog:
> http://petesbloggerama.blogspot.com
>
>
>
>
> "VB Programmer" wrote:
>
>> For those that use Microsoft Access as their website's database...
>>
>> Do you do maintenance on it on a regular basis, such as "Compact and
>> Repair"?
>>
>> Do I have to worry about it becoming to big or corrupted?
>>
>> It's a shopping cart db.
>>
>> Thanks!
>>
>>
>>