"Insert into" in Databases Access2000 & 2002
Posted on 2003-03-30
I have many applications with a database created in Access 97 (with that version) and I can insert,delete,modify and open or select fields, but in access 2002(XP) or 2000 It says that the format of the database can´t be recognized.
I´ve tried to convert a database of access 2002 in the format '97.
In access 2002 I choose tools->utilities of databases->Convert database-> format Access97.
But then I try to insert or execute recordset.addnew and other operations as .movelast or similar and it says: "this operation can´t be resolved by the provider".
Somebody can help me with this?