Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Database engine could not lock table, already in use by another person or process

I am trying to use the current record on a main form [tar tracking form]![account] to run a macro.   The problem is the macro that I want to run uses the tables that the form is base on so I get the above error.

Is it possible to use the current record in this fashion by changing locks, or is there a creative work around?
0
Quadeeb2003
Asked:
Quadeeb2003
1 Solution
 
Steve BinkCommented:
If you macro is working on the current record, you'll have to save it or undo any changes before passing it to the macro.  Either that, or change the lock method to Optimistic (no locks), which I do not recommend.

If the macro only needs to get information from the table (as opposed to changing any data), make it open the recordset/query as non-updateable (like snapshot).

Regardless of what the macro is doing or what it needs to change, I still recommend you use VB.  You have alot more flexibility and options as opposed to the rather limited functionality of macros.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now