May 10 2012, 07:57 AM
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?
May 10 2012, 08:00 AM
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.
May 10 2012, 08:02 AM