MS-Access 2007

[JimP]

I'm converting a rather sizable MS-Access 2003 mdb to an MS-Access 2007
accdb. Everything seems to be slower, especially loading forms and
populating combo/list boxes on forms.

1. Is this to be expected and/or is there any workaround?
2. Is there a forum for MS-Access 2007 issues?

...sorry for the post here, but didn't know where to go.

 

[Allen Browne]

It probably will be slower, but how much slower are you talking about?

If it's an order of magnitute slower, you could try this approach instead:
1. Using Access 2003, compact, decompile, and compact the old database
again.

2. Using Access 2007, create a new ACCDB.
Turn off Name AutoCorrect.
Set minimal references.
Import everything from the A2003 database.
Compile.

I find that gives me more consistent results than converting.

There's not a special group for A2007, but you are certainly welcome to post
here.

Other general info on converting to the new version:
http://allenbrowne.com/Access2007.html

 

[JimP]

Thanks, again I'll give it a try.

It probably will be slower, but how much slower are you talking about?

If it's an order of magnitute slower, you could try this approach instead:
1. Using Access 2003, compact, decompile, and compact the old database
again.

2. Using Access 2007, create a new ACCDB.
Turn off Name AutoCorrect.
Set minimal references.
Import everything from the A2003 database.
Compile.

I find that gives me more consistent results than converting.

There's not a special group for A2007, but you are certainly welcome to
post here.

Other general info on converting to the new version:
http://allenbrowne.com/Access2007.html