Generate SQL Script

  • Thread starter Thread starter Alam
  • Start date Start date
A

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
 
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.
Click to expand...

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
 
Back
Top