Dear All,
I am facing a problem with MS Access while inserting more number records . I am using ODBC to connect with my vc++ application. Whenever I want to insert more number of records it shows an error that :"Could not update: currently locked by admin or "system user name" ". The error comes sometimes after inserting 12 or 45 or 50 records etc...
I am using referential integrity among the tables. Will it be a cause for the issue. I have tried to give some delay before each insertion then it works fine, but atleast 1.5 sec delay need to be given then only it is working properly.
How can I prevent this problem . It will be grateful if somebody come up with a solution.