Work with the Microsoft Access Make Table Query

摘要

Repetitive tasks are helpful if you're building muscles or knitting a sweater. Repetitive tasks in your database are bad, for you and your users. Sometimes they seem so insignificant you're inclined to let them just slip through the cracks, but our advice is to fill in those cracks. Anytime you give a user permission to change properties or the database design— no matter how innocent the process seems — you could end up in trouble. An example of a seemingly insignificant task is setting a table's Description property. In fact, a lot of developers and users don't even use this property. However, if you need it, you'll want it to be correct. So you set the Description properties and that's that, right? Not if your application runs Make Table queries, because these queries don't copy a table's Description property. In this article, we'll show you a short procedure that works around this behavior.