Access 2007, form delays

[judith]

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

 

[MikeJohnB]

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

 

[judith]

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]

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

 

[Allen Browne]

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.)