Results 1 to 5 of 5

Thread: 2000 to 2007

  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    I have to take a look at an Access database today that has been having problem with some of their reports since upgrading from 2000 to 2007. I don't know what the errors are yet but figured I'd check in advance to see if there are any settings in the reference libraray that differ from 2000 to 2007 that should be set and that may be causing issues. I haven't worked in 2007 yet but figured I'd start here.

    Thanks,
    Leesah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    In general, references should update themselves automatically if you open a database created in an earlier version of Access. But if you use non-standard libraries, they might not be available on thetarget PC.

    VBA security is tighter in Access 2007 - by default, your code will not run at all! The users will have to add the location of the database to their trusted locations.

    You'll find a lot of useful info in Converting to Access 2007 on Allen Browne's website.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks Hans! I appreciate the input.

    Leesha

  4. #4
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi Hans!

    Just wanted to let you know that the link you sent me to and hint re having to trust the location made me look like a genious on this new account!

    Thanks!
    Alicia

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    That's great! Glad to have been able to help.

Posting Permissions

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