The database could not lock table...

[Dleader]

Hello,
Stats: Win7 32bit, MS Access 2010 32bit


Setup: I am creating a form(obviously). This form will run 3 macros, and display the resulting outcome. The 3 macros are based on 20 or so queries that import data, compare the data to what is currently in my database, and spit out anything that does not match up. These exceptions should show up on the form.
Problem: I get the error, "The database engine could not lock table 'Import' because it is already in use by another person or process."
Question: How do I stop this popup from happening? this stops the entire process before i can do it.
Addendum: Separated, each process does what it is suppose to do, but when I try to do it in this form, I cna not get it done

Thanks!
--Joe

[Dleader]

The form is based off of the Table Import, but when I make a new form that is blank, the Macros work, until I add a feild to view the data, then BOOM! same issue.
Thanks All!
--Joe