Question

  • Creator
    Topic
  • #2342070

    Access tables linked to their own file

    Locked

    by chasmann ·

    Tags: 

    Hi

    I have a stand-alone Access file (Not FE/BE) whose tables appear to be linked back to itself – like a FE/BE! I have no idea how this came about.
    I want to separate the code and data and create a proper FE/BE set-up but I cannot export the data/definition or the definition only to another access database as Access just exports the link. Nor can I import the tables from another database – the same happens.

    If I copy the file to a new location, the tables continues to link back to the original file, but I still cannot perform any of the exports or imports.
    I have tried to use the Convert to Local Table, but Access will not allow relationships between local and linked tables: Nor can I remove relationships; I get the message ‘You can’t delete relationship inherited from a linked database’. I seem to be in a Catch-22 situation.

    I can export to Excel, build a new database and re-import, but there are relationships between tables and indexes in the tables. There are 28 tables. All would need rebuilding but I am loathe to do it in case anything gets missed.

    Has anybody had experience of this and can advise me of a way forward?

    Many thanks

All Answers

Share your knowledge