Over the past few weeks I've been looking at some code that uses DAO 3.51 to manipulate Linked-Tables in Access. The tables link to tables in other Access databases, and basically I need to re-link these tables, as the location of the files might change from time to time.
I had played with the idea of moving from DAO to ADO for data-access, but I wasn't sure if there was some way that I could still manipulate the linked tables if I totally scrapped DAO. Since I couldn't find a way, I've just stuck with DAO, but now I'm curious if there is anyway to do this without DAO.
I posted a question to ProgSoc about this, but haven't managed to get any response so far. I suspect it can't be done via ADO and SQL, but I'd love to know for certain, and I haven't seen anything that specifically says this anywhere..