用odbc写access数据库的最基本问题,我用以下方法操作多个CRecordSet的派生类向access数据库的多个表里写数据,在写入数据量不太大的时候,是正常的,可是数据量增大到1000行以上,总出现被admin用户锁定无法更新的错误。应该怎样解决。
写数据库:
CRecordSet的派生类 m_RouteDB, m_RouteDB2, m_RouteDB3, m_RouteDB4;
int m_nstep, callsign, comu_time, end_time;
//////////////////////////////////////////////////////////////
CRecordSet的派生类 m_RouteDB;
............................
1.写数据库:
writeDataBase()
{
try
{
m_RouteDB.Open(CRecordset::dynaset, "SELECT * FROM tlk_RouteBrdcst");
m_RouteDB.AddNew();
m_RouteDB.m_t = m_nstep;
m_RouteDB.m_callsign = callsign;
m_RouteDB.m_comutime = comu_time;
m_RouteDB.m_endtime = end_time;
m_RouteDB.Update();
m_RouteDB.Close();
}
catch(CDBException* e)
{
AfxMessageBox(e->m_strError);
return;
} }
写数据库:
CRecordSet的派生类 m_RouteDB, m_RouteDB2, m_RouteDB3, m_RouteDB4;
int m_nstep, callsign, comu_time, end_time;
//////////////////////////////////////////////////////////////
CRecordSet的派生类 m_RouteDB;
............................
1.写数据库:
writeDataBase()
{
try
{
m_RouteDB.Open(CRecordset::dynaset, "SELECT * FROM tlk_RouteBrdcst");
m_RouteDB.AddNew();
m_RouteDB.m_t = m_nstep;
m_RouteDB.m_callsign = callsign;
m_RouteDB.m_comutime = comu_time;
m_RouteDB.m_endtime = end_time;
m_RouteDB.Update();
m_RouteDB.Close();
}
catch(CDBException* e)
{
AfxMessageBox(e->m_strError);
return;
} }
m_RouteDB.CursorLocation = adUseClient;
m_Conn.CursorLocation = adUseClient;
新手来看:Access的特点、概念。什么是纯 ACCESS 环境?《其他》
http://access911.net/index.asp?u1=a&u2=79FAB51E12DC