Conditional Table Creation in MS-Access

Question

Sqlite has the useful "create table if not exists" syntax.

Is there an equivalent in Access, or (as it looks) do I need to build a separate way of checking first?

Answer 1

I think your question has already been answered here: http://stackoverflow.com/questions/909371/access-create-table-if-it-does-not-exist

Answer 2

Why would you want to create a table? If it's for temporary data storage then that's fine otherwise that's usuaally not required.

See the TempTables.MDB page at my website which illustrates how to use a temporary MDB in your app. http://www.granite.ab.ca/access/temptables.htm