Solved

How to extract DDL from a access database?

Posted on 2004-04-26
4
2,165 Views
Last Modified: 2012-06-27
Hi all!

I have an access database that contains information on employees and "out of office" records. I'm developing a webpage to access that information. Now I Would like to present the DDL for that database (CREATE DATABASE...etc) in a Q here at EE.

How can I do this in access 2003?

BR MaB
0
Comment
Question by:MaB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 125 total points
ID: 10917687
I'm afraid Access can't deliver this.
I know that some re-engineering tools will have this capability, check e.g.:
http://www.sybase.com/products/enterprisemodeling/powerdesigner

Nic;o)
0
 
LVL 7

Author Comment

by:MaB
ID: 10917718
Thanks!

I suspected that after looking through the menus and the access help. I'll try the sybase modeling tool or move the db to MSSQL server which has this feature.

MaB
0
 
LVL 54

Expert Comment

by:nico5038
ID: 10917973
0
 
LVL 7

Author Comment

by:MaB
ID: 10918019
Thanks, but I believe that's included in access 2003. At least it has an Upsizing wizard in the tools-database utilitys menu.

So there definetely should be success :-)

MaB
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question