•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 425,957 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,662 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1028 | Replies: 6
 |
•
•
Join Date: Dec 2007
Posts: 18
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
Table specs there a way to get this info about my tables in a text file or anything that can be copy paste . i have many tables so i cant write them one by one?
Properties
DateCreated: 08/05/2007 11:38:58 PM DefaultView: Datasheet
GUID: {guid {A79F9FC7-D630- LastUpdated: 09/05/2007 12:18:31 AM
47FB-A227-EB5202999268}}
NameMap: Long binary data OrderByOn: False
Orientation: Left-to-Right RecordCount: 5
Updatable: True
Columns
Name Type Size
ISBNNumber Long Integer 4
Quantity Double 8
Table Indexes
Name Number of Fields
PrimaryKey 1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
ISBNNumber Ascending
Properties
DateCreated: 08/05/2007 11:38:58 PM DefaultView: Datasheet
GUID: {guid {A79F9FC7-D630- LastUpdated: 09/05/2007 12:18:31 AM
47FB-A227-EB5202999268}}
NameMap: Long binary data OrderByOn: False
Orientation: Left-to-Right RecordCount: 5
Updatable: True
Columns
Name Type Size
ISBNNumber Long Integer 4
Quantity Double 8
Table Indexes
Name Number of Fields
PrimaryKey 1
Clustered: False
DistinctCount: 5
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
ISBNNumber Ascending
•
•
Join Date: Jan 2008
Location: Bangkok, Thailand
Posts: 12
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie Poster
If you are using MS Access (not just he mdb file)
Look in "database tools > data documentor" here you can generate reports on your database schema (properties). When you have created your report, right click it and choose export from the context menu. You should be good to go. I tried it using MS Access 2007, not sure about the export in earlier versions.
Look in "database tools > data documentor" here you can generate reports on your database schema (properties). When you have created your report, right click it and choose export from the context menu. You should be good to go. I tried it using MS Access 2007, not sure about the export in earlier versions.
Last edited by TheDevShop : Jan 11th, 2008 at 12:35 am. Reason: typo
•
•
Join Date: Jan 2008
Location: SE PDX, OR
Posts: 12
Reputation:
Rep Power: 1
Solved Threads: 1
Newbie Poster
Looks like Access 2003 and earlier don't have that feature, and there are multiple Office Marketplace apps for sale.
--
John Bartley K7AAY PDX OR USA
John Bartley K7AAY PDX OR USA
•
•
Join Date: Jan 2008
Posts: 29
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
•
•
•
•
Originally Posted by K7AAY 
Looks like Access 2003 and earlier don't have that feature, and there are multiple Office Marketplace apps for sale.
Don't have what feature? The documenter is available in 2000 to 2007 I know that as I have them.
•
•
Join Date: Jan 2008
Location: SE PDX, OR
Posts: 12
Reputation:
Rep Power: 1
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by boblarson
Don't have what feature? The documenter is available in 2000 to 2007 I know that as I have them.
Well, I went looking for it in 2003 following the directions the gent who mentioned the documenter used. Would you be so kind as to note the keypress sequence you use to invoke it, for I don't find it in 2003 and looked through the menus for it.
--
John Bartley K7AAY PDX OR USA
John Bartley K7AAY PDX OR USA
•
•
Join Date: Jan 2008
Posts: 29
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
That would be:
TOOLS > ANALYZE > DOCUMENTER
TOOLS > ANALYZE > DOCUMENTER
•
•
Join Date: Jan 2008
Location: SE PDX, OR
Posts: 12
Reputation:
Rep Power: 1
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by boblarson
That would be:
TOOLS > ANALYZE > DOCUMENTER
Bob's right. I THOUGHT I was looking in the right place, but I wasn't.
My apologies, and big thanks to Bob.
--
John Bartley K7AAY PDX OR USA
John Bartley K7AAY PDX OR USA
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Sony Vaio Fn key problem (Peripherals)
- URGENT: Implementing search with multiple dissimilar MySQL tables (MySQL)
- Wrong Temps? (Motherboards, CPUs and RAM)
- Compy is slow... (Troubleshooting Dead Machines)
- EDB bits and address bus bits-confused (Motherboards, CPUs and RAM)
- Script stores data in wrong MySQL columns (MySQL)
- Calander (PHP)
- Parsing html form. (PHP)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: SA Password SAPWD
- Next Thread: Using a form to automate Reports in Access 03
