P
Paul Shapiro
I have a database that's been updated from at least Access 97 (maybe Access
2, I can't remember anymore) and has been running fine in Access 2003 for
years. My client upgraded to Vista with Office 2007. Almost everything in
the database works fine, except 3 forms. Each of these forms has a tab
control. Two of the forms have subforms on some of the tabs, one doesn't.
When I try to open the forms in Access 2007 running on Vista in Virtual PC,
I get the error "There isn't enough memory to perform this operation. Close
unneeded programs and try the operation again." I can't open the form in
design mode either. Same error. All the subforms open fine, and one of the
problem forms doesn't even have subforms.
I found a fix that I don't understand. If I open the problem forms in Access
2003 and use Save As to save them under a new name, they work fine in Access
2007, without any other changes. I used the Application.SaveAsText to
extract the complete form representation for both the working forms and the
problem forms. The only differences are the GUID's assigned to the controls.
Nothing else.
Saving a new copy of the form would be an ok fix, except for one problem. I
use SourceSafe to keep the version control. If I save the forms under a new
name, I lose the version history. I've found the version history very
helpful when a new problem appears, so I'm reluctant to throw it away. I've
thought of workarounds, like keep this history and start a new project for
an Access 2007 version. That would work, but I'd prefer to avoid the
complexity if possible. Any suggestions?
Thanks, Paul Shapiro
2, I can't remember anymore) and has been running fine in Access 2003 for
years. My client upgraded to Vista with Office 2007. Almost everything in
the database works fine, except 3 forms. Each of these forms has a tab
control. Two of the forms have subforms on some of the tabs, one doesn't.
When I try to open the forms in Access 2007 running on Vista in Virtual PC,
I get the error "There isn't enough memory to perform this operation. Close
unneeded programs and try the operation again." I can't open the form in
design mode either. Same error. All the subforms open fine, and one of the
problem forms doesn't even have subforms.
I found a fix that I don't understand. If I open the problem forms in Access
2003 and use Save As to save them under a new name, they work fine in Access
2007, without any other changes. I used the Application.SaveAsText to
extract the complete form representation for both the working forms and the
problem forms. The only differences are the GUID's assigned to the controls.
Nothing else.
Saving a new copy of the form would be an ok fix, except for one problem. I
use SourceSafe to keep the version control. If I save the forms under a new
name, I lose the version history. I've found the version history very
helpful when a new problem appears, so I'm reluctant to throw it away. I've
thought of workarounds, like keep this history and start a new project for
an Access 2007 version. That would work, but I'd prefer to avoid the
complexity if possible. Any suggestions?
Thanks, Paul Shapiro