Database does not work properly in MsAccess 2000

#1 (**permalink**) 28-Jul-2006, 08:40 AM

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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13850-database-does-not-work-properly-msaccess.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13850

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

#2 (**permalink**) 28-Jul-2006, 08:40 AM

"John Chajecki" wrote in message
news:m6-dnfBFqMuzpFjZnZ2dnUVZ8tydnZ2d@pipex.net
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13850
> 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/Ac...nceErrors.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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13850

#3 (**permalink**) 28-Jul-2006, 08:40 AM

Hi John

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

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.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"John Chajecki" wrote in message
news:m6-dnfBFqMuzpFjZnZ2dnUVZ8tydnZ2d@pipex.net...
>
> 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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13850
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13850
> 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.
>
>
>
>
>
>