ACC2000: New Table Not Listed in RecordSource Property Dropdown List or Field List

ID: Q223210

The information in this article applies to:

Microsoft Access 2000

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

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

SYMPTOMS

If you create a table while a data access page is open in Design view, the new table is not available as a record source or in the field list.

RESOLUTION

Method 1

Save and close the data access page. When you reopen the data access page, the new table will be available from the RecordSource property dropdown list.

Method 2

Right-click the database name in the field list, and then click Refresh.

STATUS

Microsoft has confirmed this to be a problem in Access 2000.

MORE INFORMATION

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

Open the sample Access database file Northwind.mdb or the sample Access project file NorthwindCS.adp.

In the Database window, click Pages under Objects, and then click New.

In the New Data Access Page dialog box, click Design View, and then click OK.

Switch to the Database window, and click Tables under Objects.

Select the Employees table, and on the Edit menu, click Copy.

On the Edit menu, click Paste.

In the Paste Table As dialog box, type TestTable, and then click OK.

Switch to the new data access page, right-click in the unbound section, and then click Properties on the menu that appears.

In the Properties dialog box, click the Data tab, click in the RecordSource property box, and then click the arrow.

Note that TestTable is not listed.

Additional query words: DAP pra

Keywords : kbdta AccDAP
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug