Results 1 to 14 of 14
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Development Platforms / Missing References (Access 2k)

    I converted an Access 97 program into Access 2000 on a Windows XP computers. When I run the application it is missing reference libraries, which I don't see in the available reference list. I search the BB for libraries and read the various entries and found that I am completely clueless! I have several questions:

    1. First, the missing libraries are graph.ocx from c:Program Files Vertias SoftwareUpdate Manager and comsnap.dll from c:windowssystem32. I don't know how they even got installed. They are not on my Windows 98 / Access 2k computer. I am doing graphs but some of the places that I get compiler errors are TRIM / STRING etc.If I create a blank db on the Win98 computer the TRIM function works fine. I will be distributing to various people with various platforms. Do I try to find all compiler errors and remove? Reprogram on a new Access 2K database on the Win98 machine. (I tried to import all the ojects into a clean, new database and got all sorts of errors on compiling). I'm looking for a shorter term, quicker solution for my current project.

    2. In what environment should I develop for systems that will be distributed. Is there a real difference between Access 2000 / Access 2002 assuming that Access 97 has the all the functionality I generally need. (the only reason I switched to Access 2k is that some graphs I had in the 97 run time application didn't work in a W2K environment.

    I would appreciate any help you can give me and I apologize if this seems too basic but I couldn't find the answers in my searches.

    ASD

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    The reason that the Trim/String functions aren't working is because of the missing references.

    A missing reference will cause Access' native commands to stop functioning. It's weird, but it's the way it seems to work.

    Your file, graph.ocx, was installed by a piece of software by Veritas. I don't know what it could be, but just guessing I'd say some sort of backup software.

    Try unreferencing the ocx and then try and compile the db. That may clear it up. Although I have my doubt since you say that you are using some graphs. It should clear up Trim and String not working, but I'd bet it causes other problems, like in the code that is building or working with the graph. You will probably need to find a graph ocx the you can distribute.

    My guess as to why the apps didn't work in Win2K is because the graph.ocx wasn't distributed along with the db.

    As for what environment to develop in, that's a tough call. I do my development in the environment that closely matches my end users. It's quite easy at work, since we are standardised with Office2K on WIn2K.

    Other than that, I'm fresh out of ideas.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Adding to Bryan's comments on development environment, unless you migrate everyone to 2002, I would be certain to do development in 2000. We seen at least two separate cases where development done in 2002 would cause a workstation running Access 2000 to crash. (All it took to resolve the problem was importing all the objects into a 2000 created database, but you don't really want to risk that kind of stuff if you can avoid it.)
    Wendell

  4. #4
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Thanks for the feedback. I guess that part of my frustration is that I don't know how the other libraries got installed in Access (or are these libraries really Office-centric. Then the library list in Access accesses them all and uses them if they are there). I have installed the original Access97 program in the Win98 environment and it works, including the graphs, without the additional libraries in Access97. Also the Trim / string functions work in the Win98 environment in a new Access2k database.

    I am thinking that I will start with a clean database and start importing tables and queries first and then the forms / modules on a one by one basis to see where things fall apart. Then when I get a problem, I will see if I can program a work around using the existing libraries. I also think I should be able to recreate the graphs using MS Graph program since that is where they were originally created (in Access 97 / Graph 8).

    In a new Access 2k database, I automatically get the following libraries already checked: Visual basic For Applications, Microsoft Access 9.0, Microsoft DAO 3.6, OLE Automation. Are these the default libraries? If I do need more libraries that are already on the Access list, how do I make sure they get included on a clients computer?

    Also, if I get the Office 2000 Developer kit, will this help me?

    Again thanks for everyones' feedback. It certainly helps lower my frustration level.

    ASD

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Development Platforms / Missing References (Access 2k)

    In a new Access 2k database, you don't get the DAO 3.6 set as a default. If you convert a 97 database to 2000, you'll get that, but not if you create a new database in 2000 and import objects from 97. The default object model in 2000 and 2002 is ADO 2.1 (although I believe that Office XP installs ADO 2.6 <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>).

    If you want to be sure the references don't break on another computer, you'll need the developer's edition, which allows you to create and distribute a setup for a runtime installation of Access and includes redistributable libraries. It won't fix a problem like your Veritas graph.ocx unless you have a license that allows you to redistribute that ocx.
    Charlotte

  6. #6
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Thanks, Charlotte. Taking a quick look at prices on the internet, it seems that the Office Developer 2000 is no longer available and the Office XP Developer is now the current version. Is this true or do I need to look deeper? If I get the Office XP Developer, can I still develop in Access 2000 and then distribute through the XP Developer edition? Or am I defeating the purpose of developing in Access 2000, which seems to be the consensus?

    I am trying to get rid of the reference to the Veritas graph since I don't how it got included in the reference libraries and I want to keep this as clean as possible. As I mentioned in an earlier post, I am going to start importing my application form by form and see where these other two libraries are getting pulled in. I don't believe that I am using any functionality other than normal Access funtionality. This seems like a time consuming process but I can't see any other way to do it.

    ASD

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Development Platforms / Missing References (Access 2k)

    It's possible (and likely) that the ocx was installed on your machine as a sample if you did a full install of Office or VB. If you set a reference to it and then never used the object, the reference will still be included in your database and cause breakage on another machine.

    You can still find the developer's edition of 2000 on some web sites if you look for it. We just had a thread on that, in fact. One of the suggested sites was http://www.atomicpark.com and another was http://www.softwareoutlet.com.

    If you're developing in 2000 format for distribution then you probably need the 2000 MOD. You can create a setup with the XP version, I believe; but you can't create a 2000 format mde using the XP Developer Edition. There are also sometimes problems getting databases created in XP to open in Access 2000 on a machine with a full installation of A2k.
    Charlotte

  8. #8
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Again, many thanks. As an update, I got a copy working in a 'pure' Access 2k environement. First I started with a blank database and imported all the tables and queries from my original database. Then I started imported the modules and forms one or two at a time. After each import, I would recompile the code and check to make sure no more libraries were added to the reference list. I ended up with a couple of procedured that would not recompile. I removed them and will look at them later. They had to do with opening an instance of Word. I also have some DAO calls to convert to ADO. At least I now 'know' whats going on inthe code.

    I learned the following lessons: one, not to ignore reference libraries, especially on converting databases. Two, all the reference libraries listed are all the dll's etc installed on the computer, regardless of program.

    Always good to learn.

    ASD

  9. #9
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Well, to get the code that opens Word to work, all you need to do is set a reference to Microsoft Word 9.0 Object Library (for W2K)

    You don't need to convert DAO code to ADO (unless you want to), just unselect the ADO Reference and Select the DAO Reference.

    I know, selecting and unselecting references is what originally got you into troblue, but to make it work, you will need those references

    HTH getting you app back up and running.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  10. #10
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Thanks Bryan. Is there a way to set these libraries in code? My original intent was to distribute these as run-time apps. From the previous posts, I have decided that the Office XP Developer program would create as many problems, with its incompatibility with Access 2000, as it solves. I am on a quest to find a copy of Office 2000 Developer edition (full) but haven't found one yet. I went to the links that Charlotte suggested but couldn't find the developer edition listed. I will call them today to verify.

    Another question, does anyone have a suggestion for setting up installation disks? My guess is the volume will be low, perhaps 5-10 disks per month after an initial run of 30 or so.

    ASD

  11. #11
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Yes there is, but I'm not 100% sure how to do set references in code.

    If you are distributing this app, you don't need to set the DAO reference in code. Just set it from the VBE and forget about it. It will stay referenced when it gets distributed.

    If you don't mind rewriting a bit of code to deal with the Word Automation, have a look at Part I of the Word Automation articles I wrote, here It talks about how to decide if you should use Early Binding (with References set) or Late Binding (without references set). This may give you some more info to help you decide what to do with the Word code.

    No, for distributing, are you planning on distributing the RunTime version of Access? For that you will need to get MOD2K. It comes with the Package and Deployment Wizard. DON'T USE IT!! is the advice I always hear. I have never had the need to use it so I won't comment one way or t'other, but quite a few Access Developers that I hold in high esteem (including our own Charlotte, IIRC) say not to use it.

    Wise Installer or InstallShield with SageKey scripts seems to be the preferred methods for distributing the Runtime. However I have never used them, since I have never had to distribute a runtime.

    I have used NullSoft's NSIS Installer for distributing just MDE's.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  12. #12
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Development Platforms / Missing References (Access 2k)

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> and IMHO, but I would tread with caution in deciding to deploy run-time versions of your 2000 databases. There is quite a bit of overhead in creating and distributing a run-time version, though it does solve most of the references issues, and means users don't need to have full Access installed on their PCs. But you still need to sort through all the references issues in the development before you deploy it, and the additional overhead each time you need to put out a change may make it burdensome. If you only put out changes once or twice a year, no big deal. On the other hand, if you do it monthly or weekly, it's a big deal. In addition the install process is akin to adding a new application, rather than simply copying a front-end database to each workstation (or to a single location on a server if you choose). Just some food for thought before you leap . . . .
    Wendell

  13. #13
    New Lounger
    Join Date
    Dec 2001
    Location
    Canterbury, Kent, England
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Development Platforms / Missing References (Access 2k)

    As far as setting references in code is concerned, it certainly can be done, and it is possible to check whether a given reference is present as well. The code to do this is not mine: I cannot remember at the moment where I lifted it from, so cannot give proper credit, I

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Development Platforms / Missing References (Access 2k)

    You already have been given code to check if a reference has been set and to set a reference in code. You can also check if a reference is broken: the Reference object has an IsBroken property. However, I never had much luck using it - if a reference is broken, many functions such as Left and Date won't work any more, so chances are your code will raise an error before you have been able to repair the broken reference...

Posting Permissions

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