ACC2000: Cannot Convert MDE to Access Client-Server Application with Upsize Wizard

Article translations Article translations
Article ID: 226391 - View products that this article applies to.
This article was previously published under Q226391
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

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

Expand all | Collapse all

SUMMARY

When you try to upsize an MDE to SQL Server or the Microsoft Data Engine (MSDE) and select the "Create a new Access client/server application" option, you may receive the error message:
The Upsizing Wizard cannot convert your database to a client server database because the VBA project is password protected.

MORE INFORMATION

When you save a Microsoft Access database as an MDE, all modules and code within the database are compiled and removed. Your Visual Basic for Applications code will continue to run, but you can't view it or edit it.

If you run upsizing tools with the "Create a new Access client/server application" option, the wizard must have access to objects that were removed when you saved the database as an MDE.

You may select either the "No application changes" or "Link SQL Server tables to an existing application" options when upsizing an MDE, but if you want to create a client-server application, you must use the original Access database (.MDB).

REFERENCES

For more information about the MDE, click Microsoft Access Help on the Help menu, type MDE in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Properties

Article ID: 226391 - Last Review: October 20, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhowto KB226391

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com