2000 database working horribly in 2007

[Crazyd]

I've got a fairly complex Access database; I'd venture to say on the verge
very complex database. SQL Linking thru ODBC for most tables minus a few
temp tables. The real problem is that I have a Form with 6 pages of Tab
Controls. This particular form is very sluggish with the Tab Control Pages.
Most of the other pages are a bit slower than 2000/2003; however the tab
pages are SLOW.

Everything seems to be acting slower than 2000… I can just install 2003 on
all the computers seeing how the licenses are usually backwards compatible,
but some clients have 2007 and I’m fearful of uninstalling 2007 for 2003
(Going backwards with Office is normally ugly). Now I do use temp tables to
temporally store the data; this database was originally written for MDB
database file, but after 40 Clients on a LAN it got rather slow.

Now my database runs just fine in 2000 & 2003; I’ve tried to convert to 2007
File & several others with no help. Suggestions? Would more subForms help?
I’ve very knowledgeable of DAO, but not the newer database access…

 

[Crazyd]

Well I've read more and it seems several people have issues with 2007 speed;
Also anyone know how to with code get rid of the new access bars? By code
I've gotten rid nearly every means to access the code while it's locked (Not
MDE file so I can find and repair issues quickly.

 

[derek]

I read on a MS site somewhere that in A2007 tabbed subforms should be
re-written so the subforms are unbound until you actually click the tab that
contains them. At that time you should assign a recordsource to them. This
advice was specific to SQL backends... so sounds like it might be worth a
try.

By the way when you say get rid of Access "Bars" do you mean the ribbon?.
Search A2007 help for "enable toolbars" and the very first entry will tell
you what to do.

Derek