Richard I purchased this seminar hoping that you would provide instructions on how to write SQL code to make a table in another data base file. I cannot see that you have covered this anywhere. Specifically I am trying to create a command button in a form that prompts for a DB file location and then creates a table in that file. Can you assist me with a SQL phrase that would accomplish this?
Reply from Richard Rost:
I cover MODIFYING table design in Part 3. However, I'm pretty sure you can't use SQL statements alone to modify tables in a linked (other) database file. You can only do that with DAORecordsets.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Seminar Part 2.
