If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2000 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… |
#2
|
|||
|
|||
Code get rid of the new access bars?
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. |
#3
|
|||
|
|||
Code get rid of the new access bars?
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 "Crazyd" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|