Re: upgrade to Access 2007

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? Subdata*** Name set to "[None]" in tables?

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

"smk23" <smk23@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:96F7AC41-8B4F-4285-9762-1F525C560389@xxxxxxxxxxxxxxxx
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.
??
--
sam


"Allen Browne" wrote:

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

"smk23" <smk23@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:73453383-85DC-4B8E-AD75-0CBA86FB02D2@xxxxxxxxxxxxxxxx
>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
> -- > sam

.