Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Question Unanswered: Runtime adjustment

    Hi All,

    I have an Access 2000DB running just fine on our network over terminal server. If i put a copy of the db on my local machine and make an adjustment it all still works great. If i place the db back on the network i get several runtime errors, after some testing i found out that access causes runtime errors on commands like: format, Right$ and a lot of other default access command (which work fine until i make an adjustment, even if it's a very small change, the whole database stops working)

    I already make a new DB and imported all forms etc from the old one, no change.

    Anybody out there with ideas, suggestions ?

    All help is appriciated,

    Thanx in advance

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Check references

    Sounds like a missing reference...

    Within VBA editor


    >Tools>References

    And look for MISSING:
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Nov 2003
    Posts
    6
    Already checked, none missing

  4. #4
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91
    Originally posted by hansdb
    Already checked, none missing
    Do you use mde as libraries ?

  5. #5
    Join Date
    Nov 2003
    Posts
    6
    Originally posted by Mixirica
    Do you use mde as libraries ?
    It's a normal mdb file, not converted to mde

  6. #6
    Join Date
    Oct 2003
    Location
    São Paulo - Brazil
    Posts
    91
    Originally posted by hansdb
    It's a normal mdb file, not converted to mde
    I mean, in your refernces, is there a mde file ?

  7. #7
    Join Date
    Nov 2003
    Posts
    6
    Originally posted by Mixirica
    I mean, in your refernces, is there a mde file ?
    No, sorry misread our question

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •