Working on an Access 2003 DB. Existing form with 3 page tab control
works fine. Add a new tab, insert subform, click on form view and
parent form won't open. Not enough memory error message. Try to open
parent form in design view, can't. Not enough memory error.

Close database, replace front end file with backup copy.

Try again:
Add new page to tab control with no controls. Parent form opens fine.
Open subform in form view, it woks great.
Insert subform onto page in tab control.
NOT ENOUGH MEMORY!

Close database, replace front end file with backup.

Windows XP SP3
Office 2003 SP3
msjet40.dll v 4.0.9514.0

Researching the problem indicated the issue might be JET. I've read
there's a newer version of jet, but MS only offers the file as part of
service packs. Any attempt to install service packs results in "newer
versions already installed" message.

Question 1: Could jet be the problem, or maybe something else?
Question 2: How can I update JET? or should I?

THANKS!
THANKS!
David G.

Third try worked. No updating JET required.
I was copying/pasting controls onto the new page. This time I built
all the controls from scratch. Everything works fine.

On Thu, 17 Jun 2010 16:10:22 -0400, David G. <(E-Mail Removed)>
wrote:

>Working on an Access 2003 DB. Existing form with 3 page tab control
>works fine. Add a new tab, insert subform, click on form view and
>parent form won't open. Not enough memory error message. Try to open
>parent form in design view, can't. Not enough memory error.
>
>Close database, replace front end file with backup copy.
>
>Try again:
>Add new page to tab control with no controls. Parent form opens fine.
>Open subform in form view, it woks great.
>Insert subform onto page in tab control.
>NOT ENOUGH MEMORY!
>
>Close database, replace front end file with backup.
>
>Windows XP SP3
>Office 2003 SP3
>msjet40.dll v 4.0.9514.0
>
>Researching the problem indicated the issue might be JET. I've read
>there's a newer version of jet, but MS only offers the file as part of
>service packs. Any attempt to install service packs results in "newer
>versions already installed" message.
>
>Question 1: Could jet be the problem, or maybe something else?
>Question 2: How can I update JET? or should I?
>
>THANKS!
>THANKS!
>David G.
THANKS!
David G.

On Thu, 17 Jun 2010 16:10:22 -0400, David G. <(E-Mail Removed)>
wrote:

>Working on an Access 2003 DB. Existing form with 3 page tab control
>works fine. Add a new tab, insert subform, click on form view and
>parent form won't open. Not enough memory error message. Try to open
>parent form in design view, can't. Not enough memory error.
>
>Close database, replace front end file with backup copy.

Try importing all objects into a new MDB and see if tthat fixes things
up. Note that compact and repair only cleans up table and indexes.

>Researching the problem indicated the issue might be JET. I've read
>there's a newer version of jet, but MS only offers the file as part of
>service packs. Any attempt to install service packs results in "newer
>versions already installed" message.
>
>Question 1: Could jet be the problem, or maybe something else?

Highly unlikely.

>Question 2: How can I update JET? or should I?

Jet 4.0 has been part of the OS since Windows 2000. It's been
updated via Windows Update in Windowx XP and newer. Thus you
shouldn't be able to install the latest SP 8.0 as that is now quite
old.

So long as you are doing Windows Updates you have the latest version.
You can double check this by going into your Windows System32 folder
and looking at the version number property of msjet40.dll.

Mine is 4.0.9511.0 although that's a Windows XP version. There are
different version numbers for Win Vista and Win 7. See
http://support.microsoft.com/kb/239114 for what appears to be the
latest version numbers of the security patches involving Jet 4.0.

Tony

On Thu, 17 Jun 2010 19:23:24 -0600, Tony Toews
<(E-Mail Removed)> wrote:

>On Thu, 17 Jun 2010 16:10:22 -0400, David G. <(E-Mail Removed)>
>wrote:
>
>>Working on an Access 2003 DB. Existing form with 3 page tab control
>>works fine. Add a new tab, insert subform, click on form view and
>>parent form won't open. Not enough memory error message. Try to open
>>parent form in design view, can't. Not enough memory error.
>>
>>Close database, replace front end file with backup copy.
>
>Try importing all objects into a new MDB and see if tthat fixes things
>up. Note that compact and repair only cleans up table and indexes.
>
>>Researching the problem indicated the issue might be JET. I've read
>>there's a newer version of jet, but MS only offers the file as part of
>>service packs. Any attempt to install service packs results in "newer
>>versions already installed" message.
>>
>>Question 1: Could jet be the problem, or maybe something else?
>
>Highly unlikely.
>
>>Question 2: How can I update JET? or should I?
>
>Jet 4.0 has been part of the OS since Windows 2000. It's been
>updated via Windows Update in Windowx XP and newer. Thus you
>shouldn't be able to install the latest SP 8.0 as that is now quite
>old.
>
>So long as you are doing Windows Updates you have the latest version.
>You can double check this by going into your Windows System32 folder
>and looking at the version number property of msjet40.dll.
>
>Mine is 4.0.9511.0 although that's a Windows XP version. There are
>different version numbers for Win Vista and Win 7. See
>http://support.microsoft.com/kb/239114 for what appears to be the
>latest version numbers of the security patches involving Jet 4.0.
>
>Tony
Tony:
After trying several imports/exports and other fiddling, I trashed the
tabs approach and with an unbound form, command buttons (that mimmiced
the tabs) and VBA code to load different record sets.

It seemed that 3 tabs worked great, but as soon as I went to 4 tabs,
all hell broke loose.

Thsnkd for your comments.