upgrade to Access 2007

S

smk23

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
 
S

smk23

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

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?
 
S

smk23

where can i find autocorrect in 2007?

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


Allen Browne said:
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?
 
A

Allen Browne

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