Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Database does not work properly in MsAccess 2000

Discussion in 'Information Technology' started by John Chajecki, Jul 28, 2006.

  1. John Chajecki

    John Chajecki
    Expand Collapse
    Guest

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

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004
    Why Does The Woman Walk Behind The Man In A Sikh Wedding? Questions and Answers Apr 20, 2017
    What Does The Sikh Turban Mean? Hard Talk Mar 4, 2017
    Original Karam And Reciprocal Karam . How Does One Know ? Sikh Sikhi Sikhism Jan 22, 2017

  3. OP
    Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "John Chajecki" <jchaj@dsl.pipex.com> 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
    > 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.

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

    (please reply to the newsgroup)
     
  4. OP
    Graham Mandeno

    Graham Mandeno
    Expand Collapse
    Guest

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

    Graham Mandeno [Access MVP]
    Auckland, New Zealand

    "John Chajecki" <jchaj@dsl.pipex.com> 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 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.
    >
    >
    >
    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page