ACC2000: Unexpected Behavior Adding Individual Controls to Page (204024)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q204024
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you drag a table from the field list to a data access page and choose to place the fields as individual controls in the Layout Wizard dialog box, you may receive the following message:
You tried to drop an OLE or Long Binary column onto your data access page. There is no HTML control which binds correctly to this column type.

CAUSE

You have dragged a replicated table onto the design surface of a page, which adds all of the table fields, including the replication-specific system fields to the page.

RESOLUTION

To keep the replication-specific fields from appearing on the page, do one of the following:
  • Manually delete the replication-specific fields from the page.

    -or-

  • Add the fields from a replicated table one at a time.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

These fields will not appear in the table if you have the system objects hidden.

Some of the field names you may see are:

s_ColLineage
s_Generation
s_GUID
s_Lineage
Gen_fieldname

Steps to Reproduce Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. On the Tools menu, point to Replication, and then click Create Replica. Click Yes to close the database and create a replica. Click Yes when prompted to make a backup.
  3. Note the location of the replica, and then click OK.
  4. Click OK in the message box.
  5. In the Database window, click Pages under Objects, and then click New.
  6. In the New Data Access Page dialog box, click Design View. In the Choose the table or query where the object's data comes from list, click Shippers. Click OK.
  7. If the field list is not visible, on the View menu, click Field List.
  8. Right-click and drag the Shippers table to the unbound section of the page. On the shortcut menu, click Individual Controls.

    Note that you receive the message mentioned in the "Symptoms" section, and that two fields on the page are not in the field list.

REFERENCES

For more information about database changes when you replicate, click Microsoft Access Help on the Help menu, type changes made to your database when you use replication in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbbug kbDAP kbpending KB204024
©2004 Microsoft Corporation. All rights reserved.