Access Documentation Tool question
Moderators: chulett, rschirm, roy
Access Documentation Tool question
Is it just me or is Access built for such a simple mind that anyone used to a real database is throughly confused on how to do anything? I'd like to start with a clean mdb to run the auto-doc from Manager. I don't see anywhere through DataStage's interface to delete all from this database. It appears that TRUNCATE isn't a valid option in Access. Is my only option to run delete queries from all 27 tables?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
FYI, to save typing for those who want to delete from all tables in the Access doc_tool.mdb, there are those statements:
delete from DSArgumentMap;
delete from DSColumns;
delete from DSContainerViews;
delete from DSCustomProperties;
delete from DSDataElements;
delete from DSDLLDependencies;
delete from DSJobDependencies;
delete from DSJobParameters;
delete from DSJobs;
delete from DSLinks;
delete from DSMachineProfiles;
delete from DSObjectTypeRef;
delete from DSProjects;
delete from DSProperties;
delete from DSPropNameRef;
delete from DSRoutines;
delete from DSRtnArguments;
delete from DSRtnDependencies;
delete from DSSeqFileFormats;
delete from DSSPParameters;
delete from DSStages;
delete from DSStageTypes;
delete from DSStageVars;
delete from DSTableDefinitions;
delete from DSTransformArgs;
delete from DSTransforms;
delete from DSArgumentMap;
delete from DSColumns;
delete from DSContainerViews;
delete from DSCustomProperties;
delete from DSDataElements;
delete from DSDLLDependencies;
delete from DSJobDependencies;
delete from DSJobParameters;
delete from DSJobs;
delete from DSLinks;
delete from DSMachineProfiles;
delete from DSObjectTypeRef;
delete from DSProjects;
delete from DSProperties;
delete from DSPropNameRef;
delete from DSRoutines;
delete from DSRtnArguments;
delete from DSRtnDependencies;
delete from DSSeqFileFormats;
delete from DSSPParameters;
delete from DSStages;
delete from DSStageTypes;
delete from DSStageVars;
delete from DSTableDefinitions;
delete from DSTransformArgs;
delete from DSTransforms;
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: