VB & Database, Insufficient base table information for updating or refreshing

Insufficient base table information for updating or refreshing

Author	Message
Nicolas Lope de Barri #1 / 4	Insufficient base table information for updating or refreshing Hi: I'm getting this error message in VB6: Runtime error -2147467259 (80004005) Insufficient base table information for updating or refreshing. The error occurs when trying to use UpdateBatch on a recordset. The application connects to a Jet 3.51 db via a DataEnvironment. It works fine in Windows 95/98 but not when migrating to Windows2000/XP. All the tables are open as follows: CommandType = adCommandTable Cursor Location = adUseClient Cursor Type = adOpenKeyset LockType = adLockBatchOptimistic Also I have no SQL statements, so the semicolon problem does not apply, and all tables have their Primary Key. Workarounds: I tried upgrading from ADO 2.0 to 2.5, installing the latest MDAC, installing the VisualStudio Service Pack 5, the Windows2000 Service Pack 3, recompiling and rebuilding the installer under Windows95 with all this service packs (where it works fine) and installing it under Windows2000 and, again, I get this error. Any help would be MUCH appreciated, it urrges me to solve this issue. regards, Nico.
Sun, 16 Oct 2005 23:50:03 GMT

Boris Janischevsk #2 / 4	Insufficient base table information for updating or refreshing This issually happens when a recordset has no primary key in it. Quote: > Hi: > I'm getting this error message in VB6: > Runtime error -2147467259 (80004005) Insufficient base table > information for updating or refreshing. > The error occurs when trying to use UpdateBatch on a recordset. The > application connects to a Jet 3.51 db via a DataEnvironment. It works > fine in Windows 95/98 but not when migrating to Windows2000/XP. All > the tables are open as follows: > CommandType = adCommandTable > Cursor Location = adUseClient > Cursor Type = adOpenKeyset > LockType = adLockBatchOptimistic > Also I have no SQL statements, so the semicolon problem does not > apply, and all tables have their Primary Key. > Workarounds: I tried upgrading from ADO 2.0 to 2.5, installing the > latest MDAC, installing the VisualStudio Service Pack 5, the > Windows2000 Service Pack 3, recompiling and rebuilding the installer > under Windows95 with all this service packs (where it works fine) and > installing it under Windows2000 and, again, I get this error. > Any help would be MUCH appreciated, it urrges me to solve this issue. > regards, > Nico.
Mon, 17 Oct 2005 12:52:48 GMT

Mike Collie #3 / 4	Insufficient base table information for updating or refreshing Check 'basetablename' property of fields. -- Mike Collier BSc(Hons) Comp Sci www.adoanywhere.com http://www.adoanywhere.com/help/index.htm
Tue, 18 Oct 2005 01:07:15 GMT

Val Mazu #4 / 4	Insufficient base table information for updating or refreshing Hi Boris, You have to specify PK for your table. Otherwise provider cannot find information how to distinct records and cannot update or delete them -- Val Mazur Microsoft MVP Quote: > This issually happens when a recordset has no primary key in it. > > Hi: > > I'm getting this error message in VB6: > > Runtime error -2147467259 (80004005) Insufficient base table > > information for updating or refreshing. > > The error occurs when trying to use UpdateBatch on a recordset. The > > application connects to a Jet 3.51 db via a DataEnvironment. It works > > fine in Windows 95/98 but not when migrating to Windows2000/XP. All > > the tables are open as follows: > > CommandType = adCommandTable > > Cursor Location = adUseClient > > Cursor Type = adOpenKeyset > > LockType = adLockBatchOptimistic > > Also I have no SQL statements, so the semicolon problem does not > > apply, and all tables have their Primary Key. > > Workarounds: I tried upgrading from ADO 2.0 to 2.5, installing the > > latest MDAC, installing the VisualStudio Service Pack 5, the > > Windows2000 Service Pack 3, recompiling and rebuilding the installer > > under Windows95 with all this service packs (where it works fine) and > > installing it under Windows2000 and, again, I get this error. > > Any help would be MUCH appreciated, it urrges me to solve this issue. > > regards, > > Nico.
Tue, 18 Oct 2005 20:44:44 GMT

Page 1 of 1

[ 4 post ]