Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 203986 - Last Review: January 26, 2005 - Revision: 2.1
ACC2000: Error Adding a List Box or Dropdown List to a Page
This article was previously published under Q203986
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When you try to add a list box or drop-down list box to a data access page, you may receive the following error:
The Wizard will only run when your current database is the datasource for your page.
This behavior may occur when the following conditions are true:
- You try to add a control while the Control Wizards is enabled.
-and-
- You use different types of connection when you create and open the database. For example, you create the database by using a UNC path (\\<servername>\<sharename>\Db1.mdb), but you open the database by using a mapped drive (F:\Db1.mdb).
To correct this problem, follow these steps:
- If the field list is not visible, on the View menu, click Field List. In the field list, click the Database tab.
- Right-click the database icon. On the shortcut menu, click Connection.
- In the Select or enter a database name box, type the full path that you used when you opened the database. For example, type F:\Db1.mdb.
NOTE: If you are entering a drive letter, you must use the same drive letter that you used to open the database. - Type the user name and password, and then click OK.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kbbug kbdap kbpending KB203986 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate