SQL Server has a handy feature where you can get scripts to create tables that already exist. Does anyone know a way of getting this functionality in Access? Has someone written a library to handle this?

Access will generate code for SELECT and Action queries through Query Design mode. But it won't generate script for things like CREATE TABLE queries etc. But you can use the code generated by SQL Server with minor modifications.

I just now found this, which looks really promising.
http://stackoverflow.com/questions/698839/...s-mdb-database/