Delete not working consistently after upsizing to sql BE/Access md

H

Holly

This code (which executes after clicking a command button from a form) worked
fine before upsizing...

DoCmd.RunCommand acCmdDeleteRecord

now only works randomly. Sometimes I can delete one or two records, but
other times it hangs for a minute and then I get a Run time error 2501: The
RunCommand action was cancelled. However, if I click debug, I can step
through the code manually, and it deletes the record fine. I also tried to
delete records straight from the table and that works fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RunCommand action was canceled 3
Run Time error 3156 ODBC Delete on a linked table TABLENAME failed 0
Delete not working in Access 2007 1
Code quits after record delete 4
delete current record in form 14
Autonumber not working after upsizing 12
Delete Command Button Issue 2
Trouble upsizing Access to SQL 5

Top