Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Bangalore, IT Capital of India.

    Unanswered: how to attach SQL server 2000 tables to Access 2.0 mdb



    I am having nearly 80 MB of coding in MS Access 2.0, only frontend
    containing forms reports, macros etc. and not database My database size is 400 MB.

    My database (Backend) MDBs are different from the frontend MDBs. I am attaching the tables from backend MDBs to frontend MDB.

    I am very much happy with the frontend. Now i want to put my database on SQL2000 and still use the Access 2.0 frontend.

    If it is Access 97 or 2000 frontend, it is easy to attach tables. Can you
    help me in knowing the procedure how to attach SQL server 2000 tables to Access 2.0 mdb

    Thanks a lot.

    K.L Srinivasa Rao

  2. #2
    Join Date
    Feb 2005

    ODBC is the answer

    You should create and SQL ODBC that points to your SQL database, then... in access, link a atable using the ODBC, there you'll be able to see all the tables from the database accessed from the odbc...

  3. #3
    Join Date
    Sep 2003
    MN US
    Aw dangit, I almost solved this one. Just a few more minutes and I woulda had it.

Posting Permissions

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