Troubleshoot the Upsizing Wizard

Microsoft Office Access 2003

The Upsizing Wizard doesn't upsize a switchboard manager form. The Switchboard Manager uses a table to store information about the form and is not designed for a client-server environment.

ShowI can't upsize my MDE file.

When you save a Microsoft Access database as an MDE file, all modules and source 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 Upsizing Wizard must have access to objects that were removed when you saved the database as an MDE file.

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) that the MDE file was created from.

ShowMy DDE code doesn't work in my Access project

DDE code is not supported in an Access project. If you upsize an Access database to an Access project, you will need to convert the DDE code to ADO code.

ShowMy upsized table contains no records.

A field in the table in the Access database may contain a null value for more than one record, but the Indexed property is set to Yes (No Duplicates) and the Required property is set to No. If a field in your table is indexed using these property settings, do not add more than one record that contains a null value to the column.

Remove the records with the null values and then upsize the table again.

ShowI ran out of disk space and my SQL Server database was not completely upsized.

If the Upsizing Wizard runs out of disk space on the server, the wizard halts, leaving a partial database and any devices it created on the server. If this happens, you can drop databases by using the Drop Database command (Tools menu, Database Utilities submenu) in SQL Server 2000 Desktop Engine, or by using SQL Server Enterprise Manager. For more information on SQL Server Enterprise Manager, see the SQL Server documentation.

ShowI'm having problems accessing or creating database objects

You may not have the correct permissions. You need read/design permission on all Access database objects to upsize them. You need the following permissions in a SQL Server database:

  • To upsize to an existing database, you need CREATE TABLE and CREATE DEFAULT permissions.
  • To build a new database, you need CREATE DATABASE permission, and SELECT permissions on the system tables in the Master database.
  • To create new devices, you must be a system administrator.

ShowI can’t upsize my data access pages

If the pages in your Access database are located on a web site, then the Upsizing Wizard can’t copy them. To upsize these pages:

  1. Copy all page files and related HTML files to your local computer.
  2. Open each page in the database window and change its file location.
  3. Run the Upsizing Wizard.
  4. Test your pages in the new Access project.
  5. Move the pages and all related HTML files back to the original Web site.