7 replies
by dcadmin
by rpfarrell
by tynemouth
by rpfarrell
by 4u21der
If you are running this 30 megs DB from ACCESS then its time to move it to a SQL server.
This is the 20/20 rule from MS.
20 megs or greater OR 20 or more users. Needs to be on a SQL server.
Access cannot handle that size of a DB easily. So compact or move it to a SQL DB.
Resoure:Microsoft Articles
=========================
Schedule Compacting of DB.
Article ID: Q209979
=========================
=========================
Optimize Access 2000 DB
Article ID: Q209091
=========================
Hope this helps.
Good Luck!
by rpfarrell
by rpfarrell
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending