(2003 to 2005)

Managing Linked Tables in MS-Access via SQL instead of DAO

Sat Jan 3 14:27:00 UTC+1100 2004


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..


Copyright © 2003-2005 John Elliot