每天自动化MS Access数据库修复。 [英] Automate MS Access Database Repair on daily basis .

问题描述

我是MS Access新手，我经常发现数据库损坏或有问题，我需要每天手动修复。所以我需要在一天的开始时自动化。数据库确实有一个密码供它打开。所以请帮我
创建相同。我不擅长VB所以任何脚本或宏，我需要相同的代码。

---

Prince Kher

解决方案

找出腐败的原因并停止它而不是每天都试图修复它可能更重要。 / p>

导致损坏的问题似乎是什么？

您的数据库是否已经 ？

数据库是否正确拆分为FE和BE？

您是否编译过数据库以查找代码错误？

您的代码中是否有错误检查？

您使用的是什么版本的访问权限？

I am new to MS Access , i have regular issue of DB getting corrupted or having issue , I need to manually repair on the daily basis . So I need to Automate the same on start of the day . The database does has a password for it to open . So Please help me create the same .I am not good at VB so any script or macros , i need code for the same.

---

Prince Kher

解决方案

It is probably more important to find out the cause of the corruption and stop it instead of trying to repair it everyday.

What seems to be the problem causing corruption?

Are your database Tables normalized?

Is the database properly split as FE and BE?

Have you compiles your database to look for code errors?

Do you have error checking in your code?

What version of access are you using?

这篇关于每天自动化MS Access数据库修复。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！