Creating linted tables in SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top