Insufficient base table information for updating or refreshing
Hi,
I have Win 98. each time I try to update/remove a record in Access from my application (written in VB 6.0) I got this error message:
'insufficient base table information for updating or refreshing'
I tried as it is explained in MSDN, to install MDAC 2.8, then VB 6.0 SP5, but it did not solve the problem.
Any answer will be appreciated,
Al.
[395 byte] By [
Alif] at [2007-11-19 7:28:55]
# 1 Re: Insufficient base table information for updating or refreshing
Could you please post some code so that ppl will understand where the problem is actually occuring...
Shuja
# 2 Re: Insufficient base table information for updating or refreshing
Hi,
Try this, Download and install JET 4.0 SP8 OLEDB. Jet40SP8_9xNT.exe from Microsoft or http://www.zuggsoft.com/files/Jet40SP8_9xNT.exe
Install the patch.
# 3 Re: Insufficient base table information for updating or refreshing
This error is often caused by not defining a primary key on your tables, or creating primary keys that are made up of more than one field. You should be able to uniquely identify any record in your tables with a single key value.
For example, say you have created a query that joins 2 or more tables together and you are trying to update the query itself. If you haven't definied your keys correctly, Access cannot interpret which records are due to be updated and will kick up an error.
Ensure you have valid primary keys on each of your tables.
