Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

managing growing access DB for web?

managing growing access DB for web?

managing growing access DB for web?

I maintain 4 magazine websites that are asp/accessDB driven. Currently the db is 5 mb and grows 2 mb per month.  I already had one incident of corruption and had to recreate the db and import the data to salvage.  Our site has light traffic and speed hasn't been an issue yet.  Anyone have advice on good habits for backup and maintenance to prevent corruption? Especially in regards to ensuring that updates tp DB via browser-based forms during maintenance are dealt with somehow.
Also I've heard that access starts having performance issues at 5mb and up. Is this true as I am at that threshold? I have been told that Fox Pro is more reliable and less expensive than SQL Server for the future when my db grows really big.

RE: managing growing access DB for web?

Everyone has an opinion but I think SQL Server is your better bet.  SQL Server 7 and later is very stable.  I find that the instability of a database application has more to do with the application code than the actual database.  With SQL Server you have a lot better backup, restore, security and recovery features.  Plus you can use stored procedures instead of queries and create all kinds of automated jobs for different tasks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close