Results 1 to 15 of 15
  1. 10-28-2009, 06:53 AM #1
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8

    Access 97 executables and other versions of Access

    I have a few questions regarding Access 97 and other versions of Access as we don't have time to develop .net versions of our Access 97 databases and some of our users are moving to other versions of Office/Access - I work for a local authority hence we tend to be very slow in moving to newer technology!



    We've tried converting our Access 97 databases (lots of front end forms) into Access 2000 but they fail and we don't want to install two versions of Access due to having our applications delivered via Novell to the user (PC's are locked down).

    Do we need to purchase anything to produce stand alone executables which could be used on any pc regardless of which version of Access is installed instead of using mdb/mde files?

    Would stand alone executables have all the functionality of mdb/mde files?

    Would this overcome the Office XXX version problem?

    Will newer versions of Windows become an issue (we're on a mixture of 2000 and XP at the moment)?

    Are there any issues with going down this route?

    Thanks

    Steve
    Reply With Quote Reply With Quote
  2. 10-28-2009, 08:01 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The default reference in ac97 was DAO. In ac2k it was switched to ADO. You might want to look at your references and check DAO and uncheck ADO, or at least make sure DAO is first in the list. ac2K should be able to run the ac97 without a problem.
    Reply With Quote Reply With Quote
  3. 10-28-2009, 08:06 AM #3
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    Thanks very much
    Reply With Quote Reply With Quote
  4. 10-28-2009, 08:12 AM #4
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    Doh!! It's been a long week and I've forgotten something pretty major!

    The Access 97 is used as the front end to a sql server database.

    The clocks going back have fried my brain!
    Reply With Quote Reply With Quote
  5. 10-28-2009, 08:15 AM #5
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Shouldn't make any difference. Do you know if ADO was used in the ac97 stuff or was it DAO?
    Reply With Quote Reply With Quote
  6. 10-28-2009, 08:17 AM #6
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    I have no idea, where do I need to look - it's not my development, I've just been tasked with trying to find a possible solution that doesn't involve redeveloping it all in .net!
    Reply With Quote Reply With Quote
  7. 10-28-2009, 08:26 AM #7
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    OPen the db while holding down a <SHIFT> key and then open a code module. From there go to Tools>References and see whether you have ADO or DAO checked. If both are checked, the order they are in the list is important.
    Reply With Quote Reply With Quote
  8. 10-28-2009, 08:52 AM #8
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    I did try and open it with the shift key.

    I don't have any modules, just forms that use queries and tables that are linked tables to the sql database using odbc.

    Tools doesn't have a References option.

    I'm looking in 97 as I don't have any other version of Access, do I need to look in 2000 or above?
    Reply With Quote Reply With Quote
  9. 10-28-2009, 09:03 AM #9
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try <ALT> F11 and then Tools>References
    Reply With Quote Reply With Quote
  10. 10-28-2009, 09:07 AM #10
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    not getting anything so far!
    Reply With Quote Reply With Quote
  11. 10-28-2009, 09:16 AM #11
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Hmmm...I don't have ac97 so I am just guessing it is similar to ac2002. Can you get to the code module of a form and try Tools>References? Does Help shpw you how to check references? I've heard the Help system in ac97 is a lot better than subsequent versions.
    Reply With Quote Reply With Quote
  12. 10-28-2009, 09:27 AM #12
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    I'm guessing that there isn't an option for ADO or DAO in 97 (being pre-ADO) and I'm also thinking that we're using odbc direct rather than Jet (DAO).

    I'll chase up with my line manager (as he wrote it) and see what I can find out.
    Reply With Quote Reply With Quote
  13. 10-28-2009, 09:31 AM #13
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So if you import into an ac2K mdb and check DAO and uncheck ADO does your system work or do you get errors? If errors, what sort of errors?
    Reply With Quote Reply With Quote
  14. 10-28-2009, 09:33 AM #14
    knee_boarder
    knee_boarder is offline Novice
    Windows XP Access 97
    Join Date
    Oct 2009
    Location
    North Devon
    Posts
    8
    That's a very good question, not having Access 2000, I can't actually run a test and find out!

    All I know is there are errors

    I'll see what I can find out.

    Thanks for all your help btw
    Reply With Quote Reply With Quote
  15. 10-28-2009, 09:41 AM #15
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Post back if you think I could be of further help.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Office versions with Access 2007
    By Coolpapabell in forum Access
    Replies: 0
    Last Post: 09-29-2009, 09:37 AM
  2. Problems opening Access MDB file with Access 2007.
    By BillKol in forum Security
    Replies: 32
    Last Post: 09-16-2009, 10:06 AM
  3. utilizing access forms with users that do not have DB access
    By phroche in forum Forms
    Replies: 0
    Last Post: 01-19-2007, 07:58 AM
  4. Users with different versions of Office - missing reference
    By AndrewAfresh in forum Access
    Replies: 1
    Last Post: 06-09-2006, 03:55 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums