Can I copy a table from one db to another ?

[smig]

If I want to create a new table on a customer BE can I create it on the FE snd use vba to copy it to the BE on first run ?
I do have routines to update links

 

[arnelgp]

yes.

SELECT * INTO newTableName IN bePathAndDatabaseName.accdb FROM yourTableInFE

just replace the italic names with correct names.

 

[smig]

Thank you.

*** Edit ***
This seems to work for empty tables too. Exactly what I wanted
Only thing it won't copy is the PK. This I can do with ALTER TABLE ALTER COLUMN.