423,818 Members | 2,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,818 IT Pros & Developers. It's quick & easy.

SQL view in Access2003

P: n/a
Hi everybody,
How can i get SQL Source of my tables in ACCESS 2003??

Please help. Thanks

Aug 2 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Access is not able to generate DDL for your tables.

You can list the fields and their data types using the DAO library as shown
here:
http://allenbrowne.com/func-06.html

There is a built-in documenter under:
Tools | Analyze | Documenter
or a better one here:
http://home.bendbroadband.com/conrad.../csdtools.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ou****@gmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi everybody,
How can i get SQL Source of my tables in ACCESS 2003??

Please help. Thanks

Aug 2 '06 #2

P: n/a
Hi, thanks for reply, but i ant just to know how can i get the sql view
(source code) of an already created table on the database on
ACCESS2003.
I can't see it on the GUI options.

Sorry about disturbing..

Thanks.
Moctar...

Aug 2 '06 #3

P: n/a
You can get the SQL of a query, by switching it to SQL View (View menu in
query design) or programmatically with:
? CurrentDb().QueryDefs("Query1").SQL

You cannot get SQL view of a table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ou****@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hi, thanks for reply, but i ant just to know how can i get the sql view
(source code) of an already created table on the database on
ACCESS2003.
I can't see it on the GUI options.

Sorry about disturbing..

Thanks.
Moctar...

Aug 2 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.