Insufficient base table information for updating or refreshing


01-Dec-2020 02:28

Most logical files and views created over one base table are updateable; however, certain restrictions apply.See the SQL Reference and Database Programming Reference for further details.Some applications can generate the necessary insert/update/delete SQL statements.All versions of MDAC can supply the update ability if a client side cursor is selected and the table has a unique key.Although Client Access ODBC and IBM® DB2®/400 allow certain nonstandard characters, the DB2/400 SQL Reference strongly recommends using the invariant character set.Consider changing the name(s), creating and using an SQL ALIAS, or setting the default collection to resolve the problem.The programmer can also prepare and run their own update, insert, and delete statements.

insufficient base table information for updating or refreshing-14

christian dating conversation starters

Later versions of Microsoft® Access (, for example) lifted the requirement that a unique key actually exist and prompts the user to select field(s) making up a unique key.

This error is generated by the MDAC runtime (ADO for example) when it is unable to parse the SQL select statement due to invalid characters in the library or table name.



Dive deep into the pages upon pages of live models, see who's online right now and engage in satisfying party chat or more intimate premium options.… continue reading »


Read more

For instance, today, many prostitutes go to nightclubs to find customers in East European cities.… continue reading »


Read more