Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001
    Thanked 0 Times in 0 Posts

    Linking tables in SQL (Access 2000 (9.0.6926 SP-3))

    I'm trying to split an Access Project into a front end and back end. When I try to link tables from the SQL server, the link option under File, Get External Data is not there.

    Searching the web, I've updated to SR8 because Access may have been in sandbox mode. This update did not fix the problems. The ODBC driver is installed.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Linking tables in SQL (Access 2000 (9.0.6926 SP-3))

    Access Projects (ADPs) are automatically split - the part you see in Access is the front-end, the back-end is in SQL Server. So you don't link SQL Server tables in projects, they are connected to directly using ADO in general. If you want to use ODBC links, you must use MDBs, which use the Jet interface (that's what the SR8 service release updates). If you are seriously contemplating using an Access project, you will find the support for them in 2002 (XP) or 2003 to be significantly better. If you have further questions, please post back and we'll do our best to clarify things.

Posting Permissions

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