 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 20072000 database working horribly in 2007
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… 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. 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 > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.