Converting from 2003 to 2007

[Linda]

I was trying to follow the Help and How to article from Microsoft Office
Online to convert my 2003 database to Access 2007. When I Open the database
I get a message that says an error occurred while loading the form and asks
if I want to continue loading the project. When I select Yes I get a message
that says "Invalid procedure call or argument." Selecting OK puts me in the
debugger on a line that says:
Private Sub Form_Open(Cancel As Integer)

This is a database that I inherited and must now convert to 2007. I suspect
there will be a number of VBA errors to work through. Can anyone help me get
started with this particular error and can anyone point me in the direction
of some documentation that might help me get through the migration?
Thanks in advance.

 

[Jeanette Cunningham]

Hi Linda,
don't know how you are doing the conversion, but this is what works for me.
Create a new accdb, turn off auto correct (access options | current
database).
Import everything from the a2003 database into the new database.
Now go through and fix any errors.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Allen Browne]

To locate the VBA errors:

1. Open the code window (Ctrl+G.)

2. Choose Compile from the Debug menu.
This will highlight the first error.

3. Fix the error, and repeat until there are no more errors.

If there are other problems with the database, it may help to walk through
the steps of this recovery sequence:
http://allenbrowne.com/recover.html

 

[Linda]

I had to drill down into your recovery sequence and do the import of the 2003
database to the blank 2007 database. That worked great! Two of the three
databases I did work as always. However, the third (which is the one with
the errors initially) has a couple of quirks.
One is when I double click the database file it opens in the mode for making
changes to the structure of the database, like I would see in 2003 holding
the shift key down when double clicking the file. I figure there is a
setting somewhere to take care of that, can you tell me what it is?

The other is the switchboard opens to be full screen in size rather than the
nice little form that encompasses the fields and that's about it. How do I
get this form to come up with the desired size?

Thanks so much for all your help.

 

[Jeanette Cunningham]

1. One is when I double click the database file it opens in the mode for
making changes to the structure of the database, like I would see in 2003
holding
the shift key down when double clicking the file. I figure there is a
setting somewhere to take care of that, can you tell me what it is?

Office button | Access options | Current database | Navigation
Uncheck the check box for Display Navigation Pane


2. The other is the switchboard opens to be full screen in size rather than
the
nice little form that encompasses the fields and that's about it. How do I
get this form to come up with the desired size?

Office button | Access options | Current database | Document Window Options
Choose Overlapping windows instead of tabbed windows.
On the form's property sheet, format tab, find the property called Fit to
screen and set it to No.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Linda]

The solution to number 1 did get rid of the navigation pane but they user
still had the ability to change views and edit the design of forms etc.
However, it put me on the right page to also turn off Allow Full Menus and
Allow Default Shortcut Menus. Now the database opens correctly for the users.

Number 2 I changed to Overlapping windows. The form already no to fit to
screen. I've tried some other solutions I've read to use the DoCmd.Reset
both in the Load and Close events with no success. Any other ideas?
Thanks.

 

[Jeanette Cunningham]

In the Activate event of the switchboard put this code.

Private Sub Form_Activate()
DoCmd.Restore
End Sub

Also look for any code that has-->
DoCmd.Maximise

and remove the maximise statement.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

The solution to number 1 did get rid of the navigation pane but they user
still had the ability to change views and edit the design of forms etc.
However, it put me on the right page to also turn off Allow Full Menus and
Allow Default Shortcut Menus. Now the database opens correctly for the
users.

Number 2 I changed to Overlapping windows. The form already no to fit to
screen. I've tried some other solutions I've read to use the DoCmd.Reset
both in the Load and Close events with no success. Any other ideas?
Thanks.

 

[Linda]

That did the trick. Thank you, Jeanette.