Microsoft Support

Page 41 of 650« First...102030...3940414243...506070...Last »

ACC2000: Opening Databases as Read-Only Causes Error Message

When you open a database, you may receive the following message:

The database ” is read-only.

You won’t be able to save changes made to data or object definitions in this database.

You may receive this message if you open a database under the following three conditions:

  • The file is read-only, whether or not its file attribute is set to read-only.
  • The folder in which the file resides is read-only.
  • You are using the /Ro command line parameter.

You can use the Microsoft Access security features to make all the objects
in a database read-only without having to implement any of the items above.

Article ID: 209825 – Last Review: November 2, 2013 – Revision: 3.0


Applies to
  • Microsoft Access 2000 Standard Edition
kbnosurvey kbarchive kbenv kbinfo KB209825

Read More:
ACC2000: Opening Databases as Read-Only Causes Error Message

ACC97: Input Masks Applied to Zip Code Field Ignored with Label Wizard

When you use the Label Wizard to make mailing labels and include a zip code
field in the same row as other fields, input masks applied to the zip code
field are ignored.
Input masks can only apply to a single field in a single text box. When a
text box on a report contains more than one field, the input masks for
individual fields are ignored.
Use an immediate if (IIf) statement to format the output for the zip code
field. You can change the ControlSource property of the text box that
contains the zip code field in the report’s Design view.

Using an Immediate IF to Format a Text Field

  1. Create the Labels Employees: Report by following the steps in the “Steps
    to Reproduce Behavior” section later in this article.
  2. Right-click the last text box in the Labels Employees: Report, and then
    click Properties on the menu that appears.
  3. In the Properties dialog box, click the Data tab, click in the
    ControlSource property box, and then click the Build button to the right
    of the ControlSource property box to open the Expression Builder.
  4. In the Expression Builder, change the existing formula
         =Trim(City & " " & zip)
    						

    to:

         =Trim(City & " " & IIf(Len(zip)=9,Left(zip,5) & "-" &
            Right(zip,4),zip))
    						
  5. Click OK to close the Expression Builder.
  6. Close the property sheet.
  7. On the File menu, click Save to save the report.
  8. On the File menu, click Print Preview to run the report.
CAUTION: Following the steps in this example will modify the sample
database Northwind.mdb. You may want to back up the Northwind.mdb file
and perform these steps on a copy of the database.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. Open the Employees table in Design view. Add a new field named
    Zip, and under Data Type, select Text.
  3. On the General tab, click in the Input Mask row and click the Build
    button to the right of the row. (The button with three dots on it.)
  4. In the Input Mask Wizard dialog box, select “Zip Code” from the Input
    Mask list, and then click Finish.
  5. On the View menu, click Datasheet view. When prompted to save the
    table, click Yes.
  6. Enter the following values into the Zip field for the first five
    records.
           55555-1111
           44444-
           55555-2222
           55455-
           55155-
    						
  7. Close the table.
  8. With the Employees table selected, on the Insert menu, click Report.
  9. Select Label Wizard from the list and click OK.
  10. Accept the defaults for the first two screens by clicking Next.
  11. On the third screen, build the Prototype label by moving the following
    fields to the specified rows of the label:
           First Row:   
           Second Row: 
    Third Row:
  12. Click Next.
  13. Accept the default of no sort field by clicking Next.
  14. Click Finish to create the report.

When the report opens in Print Preview, note that the zip codes are not
formatted according to the Input Mask.

For more information about using input masks, search the Help Index for
“input masks,” and then “Create an input mask to control how data is
entered in a field or control.”

For more information about the IIf() function, see the following Knowledge
Base article:

106288

(http://support.microsoft.com/kb/106288/EN-US/
)

ACC: How to Use the IIf() (Immediate If) Function

Article ID: 185970 – Last Review: November 2, 2013 – Revision: 4.0


Applies to
  • Microsoft Access 97 Standard Edition
kbnosurvey kbarchive kbprb KB185970

See original article:
ACC97: Input Masks Applied to Zip Code Field Ignored with Label Wizard

ACC: Microsoft Policy on Forgotten Password Assistance with Microsoft Access (2.0, 95, 97)

Microsoft has added database passwords and security account passwords to Microsoft Access so that you can prevent unauthorized access to important information. If you are unable to access database information because you do not know the correct password, please realize that:

MICROSOFT SUPPORT PROFESSIONALS CANNOT ASSIST, UNDER ANY CIRCUMSTANCES, IN THE BREAKING OF PASSWORDS APPLIED TO FILES AND FEATURES WITHIN MICROSOFT PROGRAMS.

For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:

189126

(http://support.microsoft.com/kb/189126/EN-US/
)

Microsoft’s Policy Regarding Missing or Invalid Passwords

Article ID: 259135 – Last Review: November 2, 2013 – Revision: 3.0


Applies to
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 97 Standard Edition
kbnosurvey kbarchive kbinfo KB259135

More:
ACC: Microsoft Policy on Forgotten Password Assistance with Microsoft Access (2.0, 95, 97)

Error message when the Application Center 2000 CLB service does not start: "Failed to obtain catalog data. %1%0"

The Microsoft Application Center 2000 Component Load Balancing (CLB) service does not start. Additionally, you receive an event error message that resembles the following in the Application log:

Event ID: 4099

Source: CLBService

Type: Error

Description:

Failed to obtain catalog data. %1%0

This event error message means that the COM+ CLB service received an error when it tried to retrieve information from the COM+ catalog. This event error message can be found on the COM+ routing server. Because of this, the COM+ CLB service will stop and might become corrupted. CLB will fail for all CLB-enabled components until this problem is resolved.

Note This problem can occur even if CLB is not used. By default, the CLB service is running in a typical Application Center 2000 Web cluster.

To resolve this problem, use the ACComPlusVerify tool to find and remove the invalid component. To do this, follow these steps:
  1. Run the following command.

    You can also run the following command to keep a reference to the invalid components.

    ACComPlusVerify -v > ACComPlusOutput.txt

    Note Depending on which applications were invalid, the applications may have to be reinstalled.

  2. Run the following command to remove the components.
  3. Run the following command again to confirm that there are no longer any invalid components.
  4. Restart the CLB service.

For more information about how to use the ACComPlusVerify tool, click the following article number to view the article in the Microsoft Knowledge Base:

299309

(http://support.microsoft.com/kb/299309/
)

How to use the ACComPlusVerify tool

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section.

Article ID: 955200 – Last Review: November 2, 2013 – Revision: 2.0


Applies to
  • Microsoft Application Center 2000 Standard Edition
kbnosurvey kbarchive kbtshoot kbPubTypeKC kberrmsg kbprb KB955200

Read more here:
Error message when the Application Center 2000 CLB service does not start: "Failed to obtain catalog data. %1%0"

MS02-041: Microsoft Content Management Server 2001 Security Update

Microsoft has released a patch for Microsoft Content Management Server (MCMS) 2001 that includes updates for the following security vulnerabilities:

  • A buffer overrun in a low-level function that performs user authentication. At least one Web page that is included with CMS 2001 passes input directly to the function, thereby potentially providing a way for an attacker to overrun the buffer. The result of exploiting the vulnerability can be to either cause CMS to fail, or to run code in the context of the CMS service (which runs as Local System).
  • A vulnerability resulting from the confluence of two flaws that affect a function that permits files to be uploaded to the server. The first flaw lies in how the function authenticates requests, and permits any user to submit an upload request. The second results because it is possible to override the upload location; although the function should upload files to a folder that only privileged users can access, it can be overridden to upload a file to a temporary folder that does allow unprivileged users to call it. By exploiting the two flaws in tandem, an attacker can upload an .asp or other file to the server, in a location from which it can be executed.
  • A SQL injection vulnerability that affects a function that services requests for image files and other resources. By exploiting the vulnerability, an attacker can run SQL commands on the server. That is, the attacker can add, change, or delete data in the CMS database, and the attacker can also run operating system commands on the server.
A supported fix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Apply it only to computers that you determine are at risk of attack. Evaluate your computer’s physical accessibility, network and Internet connectivity, and other factors to determine the degree of risk to your computer. See the associated Microsoft Security Bulletin

(http://www.microsoft.com/technet/security/bulletin/MS02-041.mspx)

to help determine the degree of risk. This fix may receive additional testing. If your computer is sufficiently at risk, Microsoft recommends that you apply this fix now. Otherwise, wait for the next Microsoft Content Management Server 2001 service pack that contains this fix.

To resolve this problem immediately, download the fix by following the instructions later in this article or contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Download Information

The following file is available for download from the Microsoft Download Center:

Collapse this imageExpand this image

Download Mcms2001srp1.exe now

(http://www.microsoft.com/downloads/details.aspx?FamilyId=5FC8420F-57AA-4359-94E3-4E98868A59BF&displaylang=en)

Release Date: August 7, 2002

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591

(http://support.microsoft.com/kb/119591/EN-US/
)

How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Installation Information

This update requires Microsoft Content Management Server 2001

313957

(http://support.microsoft.com/kb/313957/EN-US/
)

How to Obtain the Latest Content Management Server 2001 Service Pack

.

You do not have to restart your computer after you apply this update. This update does not support any setup switches.

File Information

The English version of this fix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

The following files are installed to the %MCMSDIR%Client folder:

Date         Time   Version      Size       File name
--------------------------------------------------------
24-Jul-2002  21:39  4.0.942.308  146,432    Ncbmprdr.dll
					

The following files are installed to the %MCMSDIR%ServerBin folder:

Date         Time   Version      Size       File name
------------------------------------------------------------------------
24-Jul-2002  21:40  4.0.942.308    146,432  Aesecurityservice.exe
24-Jul-2002  21:40  4.0.942.308  1,135,616  Aeserverobject.dll
24-Jul-2002  21:39  4.0.942.308     69,632  Enummembership.dll
24-Jul-2002  21:40  4.0.942.308    111,104  Ncaspextensions.dll
24-Jul-2002  21:41  4.0.942.308  1,124,352  Resolutionobjectmodel.dll
24-Jul-2002  21:40  4.0.942.308    631,296  Serverconfigurationapi.dll
					

The following files are installed to the %MCMSDIR%ServerIis_nrSystemClientui folder:

Date         Time   Size    File name
--------------------------------------
24-Jul-2002  21:06  12,744  Aecm.asp
24-Jul-2002  21:06   2,923  Login.asp
					

The following file is installed to the %MCMSDIR%ServerIis_nrSystemClientuiReport folder:

Date         Time   Size    File name
--------------------------------------------------
24-Jul-2002  21:06  13,968  Sdreportinitialize.inc
					

The following files are installed to the %MCMSDIR%serveriis_nrsystemmarshalling folder:

Date         Time   Size   File name
-------------------------------------------
24-Jul-2002  21:06  1,897  Editorupload.asp
24-Jul-2002  21:06  3,519  Resupload.asp
24-Jul-2002  21:06  3,160  Sdupload.asp
					

The following files are installed to the %MCMSDIR%ServerIis_nrSystemWbcInternalsPagetemplatePlaceholderssupport folder:

Date         Time   Size     File name
----------------------------------------------------------
24-Jul-2002  21:07   23,688  Emitterthineditie_activex.inc
24-Jul-2002  21:07  228,289  Nrdhtml.cab
					

The following files are installed to the %MCMSDIR%ServerIis_nrSystemWbcInternalsShared folder:

Date         Time   Size    File name
-----------------------------------------------
24-Jul-2002  21:07  15,161  Commonserver.inc
24-Jul-2002  21:07   7,802  Commonserver_rt.inc
					

The following file is installed to the %MCMSDIR%ServerIis_nrSystemWbcInternalsWbcfuncpagesCross-browserResourcebrowserAuthoring folder:

Date         Time   Size   File name
---------------------------------------------
24-Jul-2002  21:07  9,447  Uploadacceptor.asp
					

The following files are installed to the %WINDIR%Program filesMicrosoft content management serverShared files folder:

Date         Time   Version        Size     File name
------------------------------------------------------------------------
24-Jul-2002  21:39  4.0.942.308    338,432  Aeinterfaces.dll
24-Jul-2002  21:39  4.0.942.308     79,360  Aeusrmgr.dll
24-Jul-2002  21:39  4.0.942.308    146,432  Ncbmprdr.dll
					

NOTE: Because of file dependencies, this update may contain additional files. This update requires Microsoft Content Management Server 2001

313957

(http://support.microsoft.com/kb/313957/EN-US/
)

How to Obtain the Latest Content Management Server 2001 Service Pack

.

Microsoft has confirmed that this problem may cause a degree of security vulnerability in the Microsoft products that are listed at the beginning of this article.
For additional information about the patch, see the Readme.htm file that is included with the Mcms2001srp1.exe package.

For more information about these vulnerabilities, visit the following Microsoft Web site:

Article ID: 326075 – Last Review: November 2, 2013 – Revision: 4.0


Applies to
  • Microsoft Content Management Server 2001 Enterprise Edition
kbnosurvey kbarchive kbbug kbcontentmgtserv2001presp2fix kbfix kbqfe kbsecbulletin kbsechack kbsecurity kbsecvulnerability KB326075

Link:
MS02-041: Microsoft Content Management Server 2001 Security Update

The invoice quantity is incorrect when you try to bill a previously billed line item in Project Accounting in Microsoft Dynamics GP 9.0

In Project Accounting in Microsoft Dynamics GP 9.0, the value of the Qty field in the Invoice area of the Time and Materials Billing window is incorrect. The incorrect value occurs when you try to bill a line item that was written up or that was written down when the item was previously billed.
To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 9.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners

Customers

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section. This problem was first corrected in Microsoft Dynamics GP 9.0 Service Pack 1.

Article ID: 918544 – Last Review: November 2, 2013 – Revision: 6.0


Applies to
  • Microsoft Dynamics GP 9.0
  • Project Accounting
kbnosurvey kbarchive kbexpertiseinter kbmbsmigrate kbbug KB918544

Read more here:
The invoice quantity is incorrect when you try to bill a previously billed line item in Project Accounting in Microsoft Dynamics GP 9.0

Billing notes disappear when you change a timesheet transaction in Microsoft Dynamics GP

When you change a timesheet transaction in Microsoft Dynamics GP, you notice that billing notes disappear.

The problem occurs only when the following conditions are true:

  • You create the timesheet transaction by using a template in Personal Data Keeper (PDK).
  • You use the Date Based layout.
  • You save the billing notes on the template from which you created the transaction.

Microsoft Dynamics GP 9.0

To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 9.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners

Customers

Microsoft Business Solutions – Great Plains 8.0

To resolve this problem, obtain the latest service pack for Microsoft Business Solutions – Great Plains 8.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners

Customers

Microsoft Dynamics GP 9.0

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section. This problem was first corrected in Microsoft Dynamics GP 9.0 Service Pack 2.

Microsoft Business Solutions – Great Plains 8.0

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section. This problem was first corrected in Microsoft Great Plains 8.0 Service Pack 4.

Article ID: 915902 – Last Review: November 2, 2013 – Revision: 6.0


Applies to
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Project Accounting
kbnosurvey kbarchive kbexpertiseinter kbmbsmigrate kbbug kbmbspersonaldatakeeper KB915902

Original post:
Billing notes disappear when you change a timesheet transaction in Microsoft Dynamics GP

Error message when you try to enter a time card by duration in Microsoft Dynamics GP: "A save operation on table WipDCLabourBatchEntry Dtl failed accessing SQL Data.’"

When you try to enter a time card by duration in Microsoft
Dynamics GP, you receive the following error message:

A
save operation on table WipDCLabourBatchEntry Dtl failed accessing SQL Data.’

When you click More Information, you receive the
following error message:

Microsoft SQL Server Syntax
error converting datetime from character string.

This problem occurs
if the following conditions are true:

  • The duration of the time card is greater than 24
    hours.
  • The computer does not use the English (United
    States)
    regional settings.

Microsoft Dynamics GP 9.0

Microsoft is researching this problem and will post
more information in this article when the information becomes available.

Microsoft Business Solutions – Great Plains 8.0

Service pack information

To resolve this
problem, obtain the latest service pack for Microsoft Business Solutions -
Great Plains 8.0. For more information, visit one of the following Microsoft
Web sites, depending on whether you are a partner or a customer.

Partners

Customers

Microsoft Dynamics GP 9.0

Microsoft has
confirmed that this is a problem in the Microsoft products that are listed in
the “Applies to” section.

Microsoft Business Solutions – Great Plains 8.0

Microsoft has
confirmed that this is a problem in the Microsoft products that are listed in
the “Applies to” section. This problem was
first corrected in Microsoft Business Solutions – Great Plains 8.0 Service Pack
5.

Article ID: 922552 – Last Review: November 2, 2013 – Revision: 4.0


Applies to
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Manufacturing
kbnosurvey kbarchive kbexpertisebeginner kberrmsg kbqfe kbmbsmigrate kbbug KB922552

View post:
Error message when you try to enter a time card by duration in Microsoft Dynamics GP: "A save operation on table WipDCLabourBatchEntry Dtl failed accessing SQL Data.’"

You can still enter an account on a transaction when the "Allow Account Entry" check box is not selected in Microsoft Dynamics GP 9.0

When the Allow Account Entry check box is not selected in the Account Maintenance window in Microsoft Dynamics GP 9.0, you can still enter an account on a transaction in Project Accounting in Microsoft Dynamics GP. You do not receive an error message when you enter the account, and you can post the account successfully. This problem occurs when you enter the account on a transaction in Project Accounting in the following windows:
  • Timesheet Entry
  • Employee Expense Entry
  • Equipment Log Entry
  • Inventory Transfer
    Entry
  • Miscellaneous Log Entry
  • Billing Entry
To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 9.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners

Customers

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section.

This problem was first corrected in Microsoft Dynamics GP 9.0 Service Pack 1.

Article ID: 918551 – Last Review: November 2, 2013 – Revision: 5.0


Applies to
  • Microsoft Dynamics GP 9.0
  • Project Accounting
kbnosurvey kbarchive kbexpertiseinter kbmbsmigrate kbbug KB918551

View article:
You can still enter an account on a transaction when the "Allow Account Entry" check box is not selected in Microsoft Dynamics GP 9.0

Error message when you enter a Return w/Credit transaction for a purchase order in Microsoft Dynamics GP 9.0: "The project number entered does not exist for the given PO"

Consider the following scenario in Microsoft Dynamics GP 9.0:
  • You enter a Return w/Credit transaction for a purchase order.
  • The purchase order contains information from Project Accounting in Microsoft Dynamics GP 9.0.
  • The purchase order is moved to history.

In this scenario, you receive the following error message:

The project number entered does not exist for the given PO.

To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 9.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners

Customers

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the “Applies to” section. This problem was first corrected in Microsoft Dynamics GP 9.0 Service Pack 1.

Article ID: 918546 – Last Review: November 2, 2013 – Revision: 6.0


Applies to
  • Microsoft Dynamics GP 9.0
  • Project Accounting
kbnosurvey kbarchive kbexpertiseinter kbmbsmigrate kbbug KB918546

Visit link:
Error message when you enter a Return w/Credit transaction for a purchase order in Microsoft Dynamics GP 9.0: "The project number entered does not exist for the given PO"

Page 41 of 650« First...102030...3940414243...506070...Last »

Recent Comments

    Archives

    Categories