Creating linted tables in SQL

J

JMG

I have front end and back end databases. Is it possible to create a table in
the back end application with SQL so that it is linked in the front end? And
if so, how.

Thanks,
JMG
 
K

Klatuu

Use the CreateTable statement. See the example in Help. Open the VBA
editor, click on help ->Microsoft Jet SQL Reference->Data Definition
Language->CREATE TABLE Statement.
In the example, you will see how to open the database you want to create the
table in.
 
Top