View Full Version : make table with code


yasinercu
03-24-2007, 05:35 AM
i am sorry
im new using access
how can i make a table with code? and how can i create relationship between tables with using code?

boblarson
03-24-2007, 07:00 AM
don't post the same question in more than one category.

You can create a table with code, if you use a SQL statement (see tutorial here: http://www.1keydata.com/sql/sqlcreate.html) or you can create a make-table query in the QBE grid and save it and then call it each time you need it by using DoCmd.OpenQuery. As for relationships, I don't think you can do that programmatically, but I'm not sure.