Generate SQL Script

[Alam]

Hi,

I have altered the existing database in a new copy and created the missing
relationships and put some new fields. myquesiton is; Is there any way to
generate the alter/create table script from access? or how can I import the
amendments at existing live database.

Thankx..

Tausif

 

[Arvin Meyer]

I have altered the existing database in a new copy and created the missing
relationships and put some new fields. myquesiton is; Is there any way to
generate the alter/create table script from access? or how can I import the
amendments at existing live database.

You can certainly copy and paste the SQL from all Access queries, including
those using DDL, but there is no way to auto-generate scripts the same way
that you can in SQL-Server. There are some third-party products like Total
Access Detective from FMS which can do it for you:

http://www.fmsinc.com/products/detective/index.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access