error message

[Guest]

I am getting the following error message when I try to
rename a table using a macro called from a button on a
form.

"The database engine could not lock table "Data" because
it is already in use by another person or process".

If i run the macro by double clicking on it, it works
fine. Any thoughts?

Thanks

 

[Lynn Trapp]

Is your form bound to the table you are trying to rename?

 

[Guest]

NO

-----Original Message-----
Is your form bound to the table you are trying to rename?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.

 

[Guest]

Thank you ,...yes it was.

-----Original Message-----
Is your form bound to the table you are trying to rename?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.

 

[Lynn Trapp]

You're welcome.