Database does not work properly in MsAccess 2000

[John Chajecki]

I have created a MsAccess database on my work laptop using Access 2003. The database was saved in Access 2000 file format. I have copied the databse to my work desktop which runs Access 2000. The database loads Ok, but a lot of the macros and VBA code that creates default values for fields and does lookups does not appear to work. I have drawn a blank on knowledgebase. What might be causing this problem? Is there a different VBA syntax required for Access 2000?

There are no errors reported. Its just that the default values (e.g. automatically generated dates) and iif routines simply dont work.

 

[Dirk Goldgar]

I have created a MsAccess database on my work laptop using Access
2003. The database was saved in Access 2000 file format. I have
copied the databse to my work desktop which runs Access 2000. The
database loads Ok, but a lot of the macros and VBA code that creates
default values for fields and does lookups does not appear to work. I
have drawn a blank on knowledgebase. What might be causing this
problem? Is there a different VBA syntax required for Access 2000?

There are no errors reported. Its just that the default values (e.g.
automatically generated dates) and iif routines simply dont work.

Often when databases don't work on one particular machine, it's because
of a broken or missing reference. In this case, the fact that you are
"downgrading" some of your version-specific references makes it even
more likely. See if the steps outlined here help:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

If you have a broken reference to an Access 11 or Office 11 library,
select the corresponding "9"-version reference on the Access 2000 PC.

 

[Graham Mandeno]

Hi John

Does the VBA compile in Access 2000? (Open the code window and click
Debug>Compile <project name>

If it does not compile, the problem may be to do with missing references
(see Tools>References)

If everything appears OK, then try a compact/repair (from the database
window, Tools>Database utilities)

Post back if you're still having problems.