upgrade to Access 2007

[Guest]

I have an ms Access 2003 app but one of my users has only Access 2007
installed on her computer. I can open the 2003 app but it is extremely
sluggish in 2007. Is there an article or some info as to how to make these
compatible?

thanks

 

[Allen Browne]

Hi Sam

You may have already read this one:
http://allenbrowne.com/Access2007.html

All Tony Toews' points apply as well:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Guest]

Hi Allen,
I have considerable vba code, and it seems to hang when trying to run code.
When I step through the code, it's getting stalled on things like a simple If
statement, just stalls there for 5 or 10 seconds and finally moves to the
next line.
??

 

[Guest]

p.s. I've checked my code references and libraries. They are all there.

 

[Allen Browne]

Name AutoCorrect is off?

Database in a trusted location? That is, as defined in Access 2007 under:
Office Button | Access Options | Trust Center | Trust Center Settings

MDB or ACCDB? If MDB, is JET running in sandbox mode?

Native JET tables? Internal, or linked? Linked to another database? Long
paths in the links?

Security issues? Permissions issues? Subdatasheet Name set to "[None]" in
tables?

 

[Guest]

where can i find autocorrect in 2007?

it's and mdb with SQL 2000 backend.
--
sam

Name AutoCorrect is off?

Database in a trusted location? That is, as defined in Access 2007 under:
Office Button | Access Options | Trust Center | Trust Center Settings

MDB or ACCDB? If MDB, is JET running in sandbox mode?

Native JET tables? Internal, or linked? Linked to another database? Long
paths in the links?

Security issues? Permissions issues? Subdatasheet Name set to "[None]" in
tables?

 

[Allen Browne]

In A2007, the Name AutoCorrect options are under:
Office Button | Access Options | Current Database