locked
MS Access 2007 RRS feed

  • Question

  • Old system: sql2000 with MS Access 2003 adp front end, New(er): system sql2000 with MSAccess 2007 accdb front end

    I have successfully imported tables, tlks & forms but am unable to import my queries

    I have tried;

    Access > Import access database source (my adp)- sees eveything except the queries

    Access > Link to the data source - only sees tables & tlks

    ODBC > Import ODBC source data > machine data source  - sees tables, tlks & queries but importing them turns everything into a table

    ODBC > link to the data source > machine data source -  sees tables, tlks & queries but importing them turns everything into a table

    I cannot copy the sql code as this causes errors in access (but no issues in sql)

    anything else  i can do ?

    Friday, December 5, 2014 12:10 PM