Access 2000 conversion issues

[Guest]

Hi - I have created a database in Access 2000 that works fine. When I view
the database using Access 2003, the data entry forms stop working. Are there
any bugs I should know about or code changes in Access 2003? I have checked
the libraries and the only difference I can spot is that Microsoft Access 9.0
Object Library has been replaced by Microsoft Access 11.0 Object Library.
Any help would be fantastic!

 

[Allen Browne]

1. In Access 2003, go to :
Tools | Macro | Security
and set the value to Low.
More info:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

2. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
More info:
http://allenbrowne.com/bug-03.html

3. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact again.

4. If you have any code in the Load or Open event of this form, temporarily
comment out any error handler, so you are notified of any error.

You might also want to check your database for any structural issues that
could cause problems. Free utility:
http://allenbrowne.com/AppIssueChecker.html