Access Structure

P

Paul

How do you print out the database structure (Field names, type, size, ...)?

How do you see deleted records?

How to you compact or pack the database to remove deleted records?

Thank you for you Help.
Paul
 
K

KARL DEWEY

How do you print out the database structure (Field names, type, size, ...)?
Click on menu TOOLS - Analyze - Documenter. Select tables, queries, etc and
the options you need. Click OK, save to Word. It saves as a RTF file that
you can view, search and analyze.
How do you see deleted records?
Click to expand...
You do not. You might add a field to flag records as archived or deleted
but not gone.
How to you compact or pack the database to remove deleted records?
Click to expand...
Click on menu TOOLS - Database Utilities - Compact and Repair Database...
 
G

George Nicholson

How do you print out the database structure (Field names, type, size,
...)? Tools>Analyze>Documentor

How do you see deleted records?
Click to expand...
You don't. In some rdbms' you have the option to have records that have been
marked for deletion be visible or not. Access does not supply that option.
Once deleted records are, to all intents and purposes, "gone".
How to you compact or pack the database to remove deleted records?
Click to expand...
Tools>DatabaseUtilities>Compact
Although they aren't visible, deleted records (and deleted objects, etc.)
still take up file space until Compacted.
(and no, AFAIK, there is no reliable way to "recover" deleted records in
Access before compacting)

HTH,
 
A

Albert D.Kallal

Paul said:
How do you print out the database structure (Field names, type, size,
...)?
Click to expand...

You use tools->analyze->documenter.

DO REMEMBER to click on the "options" button and check for the "fields" the
middle option

"Names, Data Types, and Sizes"

If you choose the 3d options, then YOU DO NOT GET a columnar listing, but
zillions of pages, and will kill a tree in your printout.
How do you see deleted records?
Click to expand...

Coming from FoxPro/dbase land? Most modern database systems dumped that
feature about 15 years ago (because they now work different).

So, you can't see deleted records, nor retrieve them.

The fact of the matter is that you also don't have recordumber anymore
either in a Jet database. And, you also CAN NOT assume order of data entered
remains the same (you could with punched cards, and with systems like the
old dbase/FoxPro systems). Today, data entered in a particular order into a
database does NOT remain in that order (the order of records returned can
actually change from one instance to the next, so, as a result of this, if
you need data in a particular order, you must use sql to "tell" the data
engine what order you want).
How to you compact or pack the database to remove deleted records?
Click to expand...

You need to do a compact and repair.
 
T

Tom Wickerath

Hi Paul,

In addition to the answers that Karl, George and Albert have already
provided, I suggest downloading & installing Jeff Conrad's CSD documentor
tool. This tool will help you to document tables without requiring a whole
forest be clear cut.

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

How do you print out the database structure (Field names, type, size, ...)?

How do you see deleted records?

How to you compact or pack the database to remove deleted records?

Thank you for you Help.
Paul
 
Top