Microsoft KB Archive/159735

= Error Updating/Adding Records from Data Tracking Template =

Article ID: 159735

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q159735





SYMPTOMS
When you save a workbook that you created from one of the data tracking templates that are provided with Microsoft Excel 97, you may receive the following error:

Database is currently marked Read Only or open by another user

where is the name of the file.

You may also receive this error when you click the "Capture Data in a Database" toolbar button and update the existing database.

This problem may occur when you use the following data tracking templates:

Expense Statement.xlt

Purchase Order.xlt

Invoice.xlt.



CAUSE
This problem may occur if you performed a Run From CD or "Run from Network Server" installation when you set up Microsoft Excel.

Note that each time you save the workbook or capture the data in a database, the data in the worksheet is saved to a Microsoft Excel workbook that is a database for all of the records for the template. In a Run From CD or "Run from Network Server" installation, the default workbook that Microsoft Excel uses to store the records is in a location that is read- only. Therefore, Microsoft Excel cannot write records to the database.



RESOLUTION
To resolve this problem, specify a new location for the database. You must specify a location to which you have write permissions in order for Microsoft Excel to add and update records in the database.

The following steps illustrate how to customize the template to use a database in a location of your choice. These steps demonstrate how to do this using the Invoice template; however, you can also use these steps with the Expense Statement and Purchase Order templates.

 Copy the file Invdb.xls to a location for which you have write permissions. This file can be found in the Office\Library folder. Start Microsoft Excel 97. On the File menu, click New. Click the Excel tab. Click Invoice and click OK. On the Data menu, click Template Wizard.

(If you do not see the Template Wizard command on the Data menu, click Add-ins on the Tools menu, click "Template Wizard with Data Tracking," and click OK to load the add-in.) In Step 1 of the Template Wizard, in the Name for the Template box, type

C:\MSOffice\Templates\Excel\My Invoice.xlt

where MSOffice is the folder in which you installed Microsoft Office, and click Next.</li> In Step 2 of the Template Wizard, type \Invdb.xls where is the path to the folder to which you copied Invdb.xls in step 1, and click Finish.

NOTE: The database file used for the Expense Statement template is Expdb.xlt. The database file used for the Purchase Order template is Podb.xlt.</li> Close the workbook.</li> On the File menu, click New.</li> Click the Excel tab and select the new invoice template "My Invoice."</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL97 8.0 8.00 XL

Keywords: KB159735

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.