Anonymous_354
Duct tape lovers UNITE!
- Local time
- Yesterday, 16:18
- Joined
- Jun 6, 2007
- Messages
- 74
Ok, stupid question time. How do you get a make-table query to make a table each time the macro is run?
Running a make-table query
- Thread starter Anonymous_354
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 16:18
- Joined
- Jan 12, 2001
- Messages
- 32,040
From my latest post on your other thread -
1. Delete the table first
2. With rare exceptions you really don't need a make table query and with what you are currently doing you should actually not really be making a table for a few records as you can use a query just like a table.
3. If a query takes a long time to run, then it would probably make sense to do it - once during the time the user has the database open but continued make table queries being run will slow things down too.
4. Also, if this is shared then one person doing it will affect others. What if you run it and just as you're running it someone else tries to do so - problem...
5. Making and deleting tables will cause your database to bloat very quickly. Compacting must be done very frequently to keep the size down, but also to avoid corruption.
1. Delete the table first
2. With rare exceptions you really don't need a make table query and with what you are currently doing you should actually not really be making a table for a few records as you can use a query just like a table.
3. If a query takes a long time to run, then it would probably make sense to do it - once during the time the user has the database open but continued make table queries being run will slow things down too.
4. Also, if this is shared then one person doing it will affect others. What if you run it and just as you're running it someone else tries to do so - problem...
5. Making and deleting tables will cause your database to bloat very quickly. Compacting must be done very frequently to keep the size down, but also to avoid corruption.
Similar threads
