Access 2007, form delays judith 11/17/2008 4:29:02 PM I am just in the process of moving a 2000 Access database to 2007. Access has been upgraded to 2007 but the file format for both the front and back end are still in 2000 file format. The database appears to run fine in 2007 but has a couple of odd quirks. When typing ahead in a combo box it sometimes stops at the second letter typed Hyperlinks do not always work Information is not always passed from one screen to another All these problems are intermittent, some times work and sometimes not. It seems like the database is always trying to catch up with itself. Is there something i am missing in the settings. My next step is to save the database in 2007 format but I would really like to know if I have a problem here before I do this Thanks

RE: Access 2007, form delays MikeJohnB 11/17/2008 7:18:00 PM Why not copy your data base front end and back end, convert the copies to Access 2007, relink the tables and give it a try. You will still have the original 200k version should you have any problems??? Regards -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "judith" wrote: [Quoted Text] > I am just in the process of moving a 2000 Access database to 2007. Access has > been upgraded to 2007 but the file format for both the front and back end are > still in 2000 file format. The database appears to run fine in 2007 but has a > couple of odd quirks. > When typing ahead in a combo box it sometimes stops at the second letter typed > Hyperlinks do not always work > Information is not always passed from one screen to another > > All these problems are intermittent, some times work and sometimes not. It > seems like the database is always trying to catch up with itself. Is there > something i am missing in the settings. My next step is to save the database > in 2007 format but I would really like to know if I have a problem here > before I do this > > Thanks

RE: Access 2007, form delays judith 11/17/2008 7:26:01 PM Thanks, will try this but do you think it is the version that is causing the problems or is there something else I have missed when trying to upgrade. I have noticed a whole load of record locking times in the options on 2007 and wondered if I needed to change these from their defaults. I am using Default Record locking - no locks Open database using record locking - yes Thanks "MikeJohnB" wrote: [Quoted Text] > Why not copy your data base front end and back end, convert the copies to > Access 2007, relink the tables and give it a try. You will still have the > original 200k version should you have any problems??? > > Regards > -- > Advice to Posters. > Check your post for replies or request for more information. > Consider providing some feed back to the response you have recieved. > Kindest Regards Mike B > > > "judith" wrote: > > > I am just in the process of moving a 2000 Access database to 2007. Access has > > been upgraded to 2007 but the file format for both the front and back end are > > still in 2000 file format. The database appears to run fine in 2007 but has a > > couple of odd quirks. > > When typing ahead in a combo box it sometimes stops at the second letter typed > > Hyperlinks do not always work > > Information is not always passed from one screen to another > > > > All these problems are intermittent, some times work and sometimes not. It > > seems like the database is always trying to catch up with itself. Is there > > something i am missing in the settings. My next step is to save the database > > in 2007 format but I would really like to know if I have a problem here > > before I do this > > > > Thanks

RE: Access 2007, form delays MikeJohnB 11/17/2008 7:38:04 PM I really have to admit that I don't know enough about the record locking issues, I have a large invoice programme that sends out invoices, I had loads of problems trying to run that on 2007. I had no further issues when I upgraded it. However, I have just written another large quotation programme using access 2007 but with the database fe and be in access 2003. I have had no issues with this either so I'm am at a loss as to the benefits of upgrading. Having said that, I like the access 2007 format which allows a few more options all round. But again, copy your database fe & be and try it with recording locking. Again you will have the original to revert to. I really hope this helps just a little? The very best wishes. Mike B -- Advice to Posters. Check your post for replies or request for more information. Consider providing some feed back to the response you have recieved. Kindest Regards Mike B "judith" wrote: [Quoted Text] > Thanks, will try this but do you think it is the version that is causing the > problems or is there something else I have missed when trying to upgrade. I > have noticed a whole load of record locking times in the options on 2007 and > wondered if I needed to change these from their defaults. I am using > Default Record locking - no locks > Open database using record locking - yes > > Thanks > > "MikeJohnB" wrote: > > > Why not copy your data base front end and back end, convert the copies to > > Access 2007, relink the tables and give it a try. You will still have the > > original 200k version should you have any problems??? > > > > Regards > > -- > > Advice to Posters. > > Check your post for replies or request for more information. > > Consider providing some feed back to the response you have recieved. > > Kindest Regards Mike B > > > > > > "judith" wrote: > > > > > I am just in the process of moving a 2000 Access database to 2007. Access has > > > been upgraded to 2007 but the file format for both the front and back end are > > > still in 2000 file format. The database appears to run fine in 2007 but has a > > > couple of odd quirks. > > > When typing ahead in a combo box it sometimes stops at the second letter typed > > > Hyperlinks do not always work > > > Information is not always passed from one screen to another > > > > > > All these problems are intermittent, some times work and sometimes not. It > > > seems like the database is always trying to catch up with itself. Is there > > > something i am missing in the settings. My next step is to save the database > > > in 2007 format but I would really like to know if I have a problem here > > > before I do this > > > > > > Thanks

Re: Access 2007, form delays "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 11/18/2008 1:52:34 AM A2007 works fine with older format databases, so here's some suggestions to see if you can pin down your issues. 1. Make sure you have applied Service Pack 1 for Office 2007: http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5 2. Using Access 2007, open your forms in design view, and set the new Filter On Load property to No. That might solve your 3rd issue (passing from form to form.) 3. If multiple users are in this database at one time, split the database so each user has a separate copy of the program part on their own computer. If that's a new concept, see: http://allenbrowne.com/ser-01.html 4. Make sure the database resides in a trusted folder. Otherwise the code may not run at all. Details in the hint at the top of this page: http://allenbrowne.com/Access2007.html 5. Make sure Name AutoCorrect is off. Reasons: http://allenbrowne.com/bug-03.html 6. Open the code window, verify the references, decompile, and compile for Access 2007. Details in: http://allenbrowne.com/recover.html (It would not hurt to run through those steps.) If the combo box problem remains, how many records are there in its RowSource? There is a setting under Options that limits the list from some sources to 1000 items, and it will never load more than 64k items. The problem with hyperlinks could be several things, e.g. permissions, security settings, or mal-formed names (e.g. file names that contains a literal # character.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "judith" <judith[ at ]discussions.microsoft.com> wrote in message news:643687DF-9838-494C-B1E3-D830CF9BA408[ at ]microsoft.com... [Quoted Text] >I am just in the process of moving a 2000 Access database to 2007. Access >has > been upgraded to 2007 but the file format for both the front and back end > are > still in 2000 file format. The database appears to run fine in 2007 but > has a > couple of odd quirks. > When typing ahead in a combo box it sometimes stops at the second letter > typed > Hyperlinks do not always work > Information is not always passed from one screen to another > > All these problems are intermittent, some times work and sometimes not. It > seems like the database is always trying to catch up with itself. Is there > something i am missing in the settings. My next step is to save the > database > in 2007 format but I would really like to know if I have a problem here > before I do this > > Thanks