Front End/Back end linked Tables

[Mustafa]

Hi,

One of the features of the front end in my database is to
create tables, however the table is created in the front
end (MDE) application and not in the back end... I need
this to be the other way around! How would I create the
table in the back end (MDB) file and not in the front
end? The tables are created using SQL create table
statement in VBA beneath a button. I really hope this is
possible!!

Thanks in advance.

 

[GVaught]

Generally, you have to open the backend database and create the tables there
and then link them into the mde.

 

[Mustafa]

Can you tell me how to do that in VBA from the front end?