Create back-end table

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

Guest

Hi,
Is it possible to create a table in a back-end database using code that is
run at the front-end?

Regards,
Ron.
 
Yes, it's possible if you OpenDatabase, and CreateTable. See help on
CreateField and CreateIndex as well.

While it is possible to use a DDL query statement to insert the table into
the back end, that's not really good enough for any serious table, as you
cannot set crucial properties such as the SubDatasheetName of the table, or
the AllowZeroLength property of the fields.

For the field types you need in your DAO code compared to the names in the
interface, see:
Field type names (JET, DDL, DAO and ADOX)
at:
http://allenbrowne.com/ser-49.html
 
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

How to creat a new table to the back end (BE) from the front end ( 4
Front-end back-end 4
ms access with sql server 2
Scanning for new tables in a Back End (BE) database 8
Can DoCmd.TransferDatabase be used to move table to BE 6
Code not linking to a BE table 2
Compact database thru VBA 8
TransferDatabase problem 6

Back
Top