Results 1 to 14 of 14
  1. #1
    Join Date
    May 2008
    Location
    London, UK
    Posts
    46

    Unhappy Unanswered: Help!! Database not working in Access 2002!

    Hello!

    I'm having major issues (driving me mad! ), I have created the attached database in Access 2003, the PC's it will be running on are using Access 2002.

    Now to my problems, it seems like all the items I have coded (with some major assistance of the members of this board) do not want to work on the PC's with Access 2002 & I'm not sure if this is the way it has been created or if it is due to the restrictions imposed on the PC's that will be running it?

    I am getting multiple errors, the first is:

    "Your database or project contains a missing or broken reference to the file 'Mscomct2.ocx' version 2.0"

    I have located this file but do not have admin privildges on the machines so can not use the run comand to install it! Is there a work around for this?

    The Login form which works perfectly on all my other machines give the error:
    "Compile Error - Can not find project or library" on this part of the "Private Sub cmdLogin_Click()"
    Code:
    MyForm = DLookup("OpenSwitchboard", "tblAuthorisedUsers", "[Username]='" & Me.txtUsername & "'")
    There are a few other things, the date control doesn't work, I'm assuming this is due to 'Mscomct2.ocx'; The table "tbl_LFT_Main" gives an error on opening "The Function you entered can not be used in this expression" there seem to be many more!

    If I had any hair I would have pulled it out by now!

    If anyone has any Ideas that could help me I would be very greatful!

    I was really starting to see an end in sight for this project but now I feel like I'm back to square 1!!! HELP!!

    Regards,

    Mike
    Last edited by setab; 07-22-08 at 03:26. Reason: Removed Attachment

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    first off
    treat this as a learning experience... develop in the same version as the platform you are going to deploy. theres no point developing things in a ore recent version than your target user group have access to.

    as regards the admin privileges.. talk to the network trolls who maintain the network and get them to ensure the relevant contorls are available on the client machines. if they have tied own the security.. then they must have den it for a purpose, and they must have the ability to install controls. alternativley logon to those PC's with an administrator account.

    afaik there is no licensing issue on Mscomct2.ocx its just an installation / config issue
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by healdem
    first off
    treat this as a learning experience... develop in the same version as the platform you are going to deploy. theres no point developing things in a ore recent version than your target user group have access to.

    I can attest to that. I was going to develop the DBs I need in Access 2007 since that's what I use at the house and wanted to learn it better. Work uses 2003, while I know I can save down in Access 2007 to a 2003 file format, I just don't want to bother since I know I can make things look "prettier" in 2007 but when they transfer back, it'll be lost anyways, so what's the point. Or, like you're having issues, I'll have issues.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    develop in the same version as the platform you are going to deploy.
    100% Agreed. At a pinch I will develop something in an earlier version, because you can upgrade to it, but I would never code something in a later version as you can develop using features that are just not available in the earlier version and you can't always convert backwards successfully.

    I also NEVER use the Calendar control.

    Most of your issues seem to be in Tools - References though, so you might get lucky. Try creating a blank database on the site where it is going to run and take it to the development machine. Import all the objects from your project into the blank database. Test, debug and re-distribute back to the site. If all goes well, most of these problems will disappear.

    Good luck!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    May 2008
    Location
    London, UK
    Posts
    46
    Thanks, lesson learned! I'm sure you will be hearing from me soon!

  6. #6
    Join Date
    May 2008
    Location
    London, UK
    Posts
    46


    I just installed Access 2002 on my laptop and the DB works perfectly?

    I am really confused now, my laptop and the PC's the DB will be running on are both using SP3?

    My Laptop is using v.10.6501.6626
    and the Problem PCs are running v.10.6771.6839

    I have installed 2002 without removing access 2003, is it working because it is using something from 2003, or is the issue more likely with the install PCs?

    (Have removed the Calendar Control!)

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Since you still have 2003, my guess is that your DB is using something (probably a reference) that is only there with machines that have 2003.

    Try creating a blank database on the site where it is going to run and take it to the development machine. Import all the objects from your project into the blank database. Test, debug and re-distribute back to the site.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    May 2008
    Location
    London, UK
    Posts
    46
    Will do! I'm also going to try and use a couple of other machines on the network as apparently some have more issues than others!!!

    Any ideas why "=Date()" does not work in the default value for a cell in a table in the version of 2002 being use by the "Problem PCs"?

    I am mistified to see that doesn't display this correctly (displays "#Name?" in the field).

    Is there another expresion that should be used?

  9. #9
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    I ddn't use 2002 for so long and cant remember the orrect syntax it may be "=Date" but you can use 2002 help to see what is the correct syntax?
    Cheers.
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No, =Date() is fine. If =Date() doesn't work, then I'm convinced you have a Tools - References problem. Go there and find out what you have ticked and either screen shot it or detail it and let us know. I'm not sure what exactly is needed off the top of my head, but I can look at it later.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    May 2008
    Location
    London, UK
    Posts
    46
    Please find attached a screen shot of the References options, I have highlighted one "MISSING: Microsoft Windows Common Controls" which I'm sure isn't helping!
    Click image for larger version. 

Name:	22-07-2008 11-07-06.jpg 
Views:	38 
Size:	593.7 KB 
ID:	8593
    The screen shot was take with snagit so is the full list so is quite long!

    Thanks for your help!

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, that missing reference is going to be causing quite a few issues. Untick it. Leaving it ticked will only cause problems.

    Hopefully that will solve your =Date() problem.

    Of course, I have to wonder if you were using it because it's not in your list of references... or mine.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  13. #13
    Join Date
    May 2008
    Location
    London, UK
    Posts
    46
    Code:
     ____________ ___  _____ _______._____  ____ ._  __ ._  __  ____ ._____   
    / ___/\_   _//   ||  _  \\_   _/|  _  \| ___|| |/ / | |/ / | ___||  _  \  
    \___  \ | | / /| ||  _  /  | |  |  _  /|  _> | ._ \ | ._ \ |  _> |  _  /  
    /___  / |_|/_/ |_||_| \ \  |_|  |_| \ \|____||_| \_\|_| \_\|____||_| \ \
        \/.                \_\           \_\             ...strikes again \_\
    Genius. Once that reference was unticked, everything... and I mean everything - works like magic! LEGEND!!!

    Thanks everyone for your input, greatly appreciated!

    One of the best things I ever did joining this forum, starting not to think the worst thing I ever said was "Sure, I'll have a go at that for you"!!!

    Again, thanks sooo much for all your help!

    Mike

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Holy .... buckets!! That's a nice text based StarTrekker banner!! I appreciate the time you must have taken to do that! Copied it btw

    And you're welcome!
    Attached Thumbnails Attached Thumbnails ST3_PicardSIG.gif  
    Last edited by StarTrekker; 07-22-08 at 11:03.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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