ACC2: Sample MSACC20.INI File for MS Access Version 2.0

• Microsoft Access version 2.0

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

This article contains the contents of a generic MSACC20.INI file for Microsoft Access version 2.0. The MSACC20.INI file is created by Microsoft Access Setup. If the MSACC20.INI file in your Windows directory is damaged or removed, you can run Setup again, or you can create a new file by re- creating the generic file below. Note that the MSACC20.INI file is a text file and can be created with any text editor (such as Notepad).

MORE INFORMATION

To create a new MSACC20.INI file, re-create the following file using any text editor and then save the file in your Windows directory as MSACC20.INI. Note that the following file is an example only; you must use appropriate paths and filenames for your installation in the [Options] section of the file.

Generic MSACC20.INI File Contents

NOTE: In the following sample file, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when re-creating this file.

   ;=====================================================
   ;     Generic MSACC20.INI file for version 2.0
   ;=====================================================

   [Options]
   SystemDB=C:\ACCESS\system.mda        ;path may differ
   UtilityDB=C:\ACCESS\utility.mda      ;path may differ
   AllowCustomControls=1
   AllowOLE1LinkFormat=0

   [Clipboard Formats]
   Microsoft Excel (*.xls)=soa200.dll,1,xls
   Rich Text Format (*.rtf)=soa200.dll,2,rtf
   MS-DOS Text (*.txt)=soa200.dll,3,txt

   [Report Formats]
   Microsoft Excel (*.xls)=xls,SOA_RptToBIFF,Biff3,Microsoft Excel (*.xls)
   Rich Text Format (*.rtf)=rtf,SOA_RptToRTF,Rich Text Format,Rich Text _
      Format (*.rtf)
   MS-DOS Text (*.txt)=txt,SOA_RptToAscii,1,MS-DOS Text (*.txt)

   [Microsoft Access]
   Filter=Microsoft Access (*.mdb)|*.mdb|All Files (*.*)|*.*|
   Extension=mdb
   OneTablePerFile=No
   IndexDialog=No
   Maximized=1
   CreateDbOnExport=No
   Tutorial=1

   [Delimited Text]
   Filter=Delimited Text (*.txt)|*.txt|All Files (*.*)|*.*|
   Extension=txt
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Fixed Width Text]
   Filter=Fixed Width Text (*.txt)|*.txt|All Files (*.*)|*.*|
   Extension=txt
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Word for Windows Merge]
   Filter=Text (*.txt)|*.txt|All Files (*.*)|*.*|
   Extension=txt
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Microsoft Excel 2.0-4.0]
   Filter=Microsoft Excel (*.xls)|*.xls|All Files (*.*)|*.*|
   Extension=xls
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Microsoft Excel 5.0]
   Filter=Microsoft Excel 5 (*.xls)|*.xls|All Files (*.*)|*.*|
   Extension=xls
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=Yes

   [Lotus WKS]
   Filter=Lotus 1-2-3 (*.wks)|*.wks|All Files (*.*)|*.*|
   Extension=wks
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Lotus WK1]
   Filter=Lotus 1-2-3 (*.wk1)|*.wk1|All Files (*.*)|*.*|
   Extension=wk1
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Lotus WK3]
   Filter=Lotus 1-2-3 (*.wk3)|*.wk3|All Files (*.*)|*.*|
   Extension=wk3
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Menu Add-Ins]
   &Add-in Manager==Wm_Entry()
   &Database Documentor==Doc_PrintDataBase()
   A&ttachment Manager==Am_Entry()
   Im&port Database...==Doc_ImportDatabase()
   &Menu Builder==CustomMenuBuilder()

   [Libraries]
   wzlib.mda=rw
   wzTable.mda=rw
   wzQuery.mda=rw
   wzfrmrpt.mda=rw
   wzbldr.mda=rw

   [Table Wizards]
   Table=TW_Entry,,{This wizard creates a new table to store data.}

   [Table Wizard Data Files]
   wztbldat.mdt=Standard Microsoft Sample Fields

   [Query Wizards]
   Crosstab Query=Xtq_Entry,,{This wizard creates a crosstab query that _
      displays data in a compact, spreadsheet-like format.}
   Find Duplicates Query=dup_Entry,,{This wizard creates a query that _
      finds duplicate records (rows) in a single table or query.}
   Find Unmatched Query=dwz_Entry,,{This wizard creates a query that _
      finds records (rows) in one table that have no related records in _
      another table.}
   Archive Query=arc_Entry,,{This wizard creates a query that copies _
      records from an existing table into a new table.}

   [Form Wizards]
   Single-Column=zwForm, 1,{This wizard creates a form that displays _
      fields in a single column.}
   Tabular=zwForm, 2,{This wizard creates a form that displays each _
      record as a row of fields.}
   Graph=zwGraph,, {This wizard creates a form that displays a graph.}
   Main/Subform=zwMainSub,, {This wizard creates a form that contains _
      another form.}
   AutoForm=zwAutoForm,, {AutoForm automatically creates a simple form _
      based on the selected table or query.}

   [Report Wizards]
   Single-Column=zwReport, 3, {This wizard creates a report that displays _
      fields in a single column.}
   Groups/Totals=zwReport, 4, {This wizard creates a report that groups _
      records together and displays totals for each group.}
   Mailing Label=zwMailingLabel,, {This wizard creates standard Avery _
      mailing labels.}
   Summary=zwReport, 12, {This wizard creates a report that displays _
      totals for groups of records.}
   Tabular=zwReport, 11, {This wizard creates a report that displays _
      each record as a row of fields.}
   AutoReport=zwAutoReport,, {AutoReport automatically creates a simple _
      report based on the selected table or query.}
   MS Word Mail Merge=PM_Entry,, {This wizard links your data to a _
      Microsoft Word document, so that you can print form letters or _
      address envelopes.}

   [Control Wizards]
   MSListBoxWizard=ListBox, list box Builder, LST_ENTRY,w
   MSComboBoxWizard=ComboBox, combo box Wizard, CMB_ENTRY,w
   MSOptionGroupWizard=OptionGroup, OptionGroup Wizard, OGrp_ENTRY,w
   MSCommandButtonWizard=CommandButton, command button Wizard, BW_ENTRY,w

   [Property Wizards]
   MSMenuBarBuilder=Menubar, MenuBar Builder, MB_ENTRY,rw
   MSInputMaskWizard=InputMask, Input Mask Builder, IM_ENTRY,rw
   MSForeColorBuilder=ForeColor, ForeColor Builder, CP_ENTRY,rw
   MSBackColorBuilder=BackColor, BackColor Builder, CP_ENTRY,rw
   MSBorderColorBuilder=BorderColor, BorderColor Builder, CP_ENTRY,rw
   MSPictureBuilder=Picture, Picture Builder, PP_ENTRY,rw
   MSODBCConnectStrBuilder=ODBCConnectStr,ODBC ConnectString
    Builder,zwBuilderODBCConnectString,rw
   MSFieldBuilder=FieldName,Field Builder,tw_FieldEntry, rw

   [ISAM]
   PageTimeout=5
   LockedPageTimeout=5
   CursorTimeout=10
   LockRetry=20
   CommitLockRetry=20
   MaxBufferSize=512
   ReadAheadPages=16
   IdleFrequency=10

   [Paradox 3.X]
   Filter=Paradox (*.db)|*.db|All Files (*.*)|*.*|
   Extension=db
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Paradox 4.X]
   Filter=Paradox (*.db)|*.db|All Files (*.*)|*.*|
   Extension=db
   OneTablePerFile=Yes
   IndexDialog=No
   CreateDbOnExport=No

   [Installable ISAMs]
   Paradox 3.X=C:\WINDOWS\SYSTEM\pdx200.dll
   Paradox 4.X=C:\WINDOWS\SYSTEM\pdx200.dll
   FoxPro 2.5=C:\WINDOWS\SYSTEM\xbs200.dll
   FoxPro 2.6=C:\WINDOWS\SYSTEM\xbs200.dll
   FoxPro 2.0=C:\WINDOWS\SYSTEM\xbs200.dll
   dBASE III=C:\WINDOWS\SYSTEM\xbs200.dll
   dBASE IV=C:\WINDOWS\SYSTEM\xbs200.dll
   Btrieve=C:\WINDOWS\SYSTEM\btrv200.dll

   [Paradox ISAM]
   ParadoxUserName=rms
   ParadoxNetPath=C:\ACCESS
   ParadoxNetStyle=3.x
   CollatingSequence=Ascii

   [FoxPro 2.0]
   Filter=FoxPro 2.0 (*.dbf)|*.dbf|All Files (*.*)|*.*|
   Extension=dbf
   OneTablePerFile=Yes
   IndexDialog=Yes
   IndexFilter=FoxPro Index (*.idx;*.cdx)|*.idx;*.cdx|All Files (*.*)|*.*|
   CreateDbOnExport=No

   [FoxPro 2.5]
   Filter=FoxPro 2.5 (*.dbf)|*.dbf|All Files (*.*)|*.*|
   Extension=dbf
   OneTablePerFile=Yes
   IndexDialog=Yes
   IndexFilter=FoxPro Index (*.idx;*.cdx)|*.idx;*.cdx|All Files (*.*)|*.*|
   CreateDbOnExport=No

   [FoxPro 2.6]
   Filter=FoxPro 2.6 (*.dbf)|*.dbf|All Files (*.*)|*.*|
   Extension=dbf
   OneTablePerFile=Yes
   IndexDialog=Yes
   IndexFilter=FoxPro Index (*.idx;*.cdx)|*.idx;*.cdx|All Files (*.*)|*.*|
   CreateDbOnExport=No

   [dBASE III]
   Filter=dBASE III (*.dbf)|*.dbf|All Files (*.*)|*.*|
   Extension=dbf
   OneTablePerFile=Yes
   IndexDialog=Yes
   IndexFilter=dBASE Index (*.ndx)|*.ndx|All Files (*.*)|*.*|
   IndexExtension=ndx
   CreateDbOnExport=No

   [dBASE IV]
   Filter=dBASE IV (*.dbf)|*.dbf|All Files (*.*)|*.*|
   Extension=dbf
   OneTablePerFile=Yes
   IndexDialog=Yes
   IndexFilter=dBASE Index (*.ndx;*.mdx)|*.ndx;*.mdx|All Files (*.*)|*.*|
   CreateDbOnExport=No

   [dBase ISAM]
   CollatingSequence=Ascii
   Century=Off
   Date=American
   Mark=47
   Deleted=On

   [ODBC]
   QueryTimeout=60
   LoginTimeout=20

   [Btrieve]
   Filter=Btrieve (file.ddf)|file.ddf|
   Extension=ddf
   OneTablePerFile=No
   IndexDialog=No
   CreateDbOnExport=Yes

   [Btrieve ISAM]
   DataCodePage=OEM

REFERENCES

For more information about Customizing ODBC settings within the Windows 95 registry, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q139044
   TITLE:      ACC95: How to Add Former MSACC20.INI ODBC Section to
               Registry