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

    Re: Converting from 97 to 2000 (97)

    You need to open the database that the linked tables are in.

    To find out where the linked database is, Open the converted DB in A2K, select Tools | Database Utilities | Linked Table Manager. In the Linked Table Manager window you should see most of the full path to the linked DB.
    --
    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

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting from 97 to 2000 (97)

    I was practicing converting a 97 database to a 2000 database. When I brought it up in Access 2000, it gave me the option to convert so I did. When I open the2000 database the tables are linked and when I open up the Access 97 database, the tables are linked. If I want to make some changes to a table, how do I do this? Maybe I missed something but I thought when I converted to 2000 I wouldn't have linked tables.

    I have another question - When I split a database into a front end and a back end it was suggested to put the front end on the individual user's PCs and the backend on a shared drive. If I have to make changes to forms or add reports, would I have to copy a new front end to each user? Can I put the front end on the share drive too?

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Converting from 97 to 2000 (97)

    Have you converted both the FE and BE databases from Access 97 to Access 2000?
    If you have you will need to do as Bryan suggests to find where the tables are linked to.
    When you convert from Access 97 to 2000 with linked you will have linked in the output (2000).

    If you put the FE on the shared drive as well you will get some conflicts when exitting from forms about saving the form. This happens when someone else changes a form (eg the filter) and exits, it tries to write the form back to the DB. Then when another user exits they then will be asked to write the form back to the DB. It really is a pain in the proverbial. The best way around this is to keep the FE on the users PC.

    If you want a better and more eloquent explanation of this do a search of this forum.
    HTH
    Pat

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

    Re: Converting from 97 to 2000 (97)

    If you had linked tables in 97, you'll have linked tables in 2000. You may be getting confused by the Access Data Project (ADP), available in Access 2000. That is a direct window into SQL Server, so no linked tables.
    Charlotte

Posting Permissions

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