CREATE TABLE (sql) in another db - possible?

[Happy YN]

Can a CREATE TABLE sql create a table in a different file? More specifically I want to use it to Create a table in the backend and if yes how could one link to it?
I know the table could be created, copied to a different db and then deleted but I was hoping there's syntax in the CREATE TABLE to do all this for me!
Thanks

 

[namliam]

Create the Create Table querie in the query builder and copy the syntax.

You can create a link in vba as well, no problems... just search the forum...

Regards

 

[Happy YN]

One can't create a CREATE TABLE sql in the query builder, it has to be manually typed in!Its called a Data Definition query.
I have overcome the problem by creating the table in the current db, copying it to the backend,deleting it from front end and then linking it to the current db. All this is done in a loop for each table enumerated in an external ini file, but it would still be better to create it in the backend to start with.
I would still like an easy way to create relationships. I have some dao code but I'm looking for something better
Thanks