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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ms access with sql server 2
Access to remote SQL server 14
Access-SQL Server object dependencies 3
ADO 1
Alter Back-End Table from Front-End 5
Code not linking to a BE table 2
Access Form Refresh 1
odbc - call failed: communication link failure 3

Back
Top