Need Code to add table to BE if it doesn't exist

[1eye1vision]

Hi All,
I'm trying to figure out how to create a table in the linked BE of my DB if it doesn't exist, i have tried several methods but i am still having difficulty working this out.
Any Help or samples would be appreciated.

 

[John Big Booty]

Have you had a look at a make table query? However it does rather beg the question as to why you would want to create a table at this point

And you will still need to re-link any new tables to your front end.

 

[gemma-the-husky]

much easier to copy a table over.

if it doesn't exist you need to create the table, add all the fields with the correct characteristics, and add at least a primary key, and maybe other indexes.

not trivial in code.

 

[1eye1vision]

What would be the code to copy a table over to the backend...???
I have figured out the code to add fields to an existing table, but not joy with the other..

 

[gemma-the-husky]

look at docmd.transferdatabase