Re: Change reference to a linked table using VBA ... >I have question with regards to link tables. ... >I have a liked table and would like to change it's source while keeing the ... Use DAO to change the TableDef's SourceTableName property. ... You should also use the TableDef's RefreshLink method after ... (microsoft.public.access.modulesdaovba)
Re: Multi-select parameter via Query Grid ... Thank you for your suggestion.... I have never used DAO but am willing to learn. ... Can I use this to change just the WHERE clause, which is what I want to do, ... >> Thanks and regards... (microsoft.public.access.queries)
Re: "User-defined type not defined" ... The next step is to open any code module then Tools|References and make sure ... you have DAO 3.6 Object Library checked ...Regards,...Dave Patrick ....Please no email replies - reply in newsgroup. ... (microsoft.public.access.modulesdaovba)
Error 3043 Disk or Network Error See General 2 Forum ... I am posting this thread here under Modules / DAO / VBA because this error ... I don't want to cross-post, please, read details and ...Regards,... (microsoft.public.access.modulesdaovba)
Re: Replacement for Dao ... you may have gotten a bit of bad info -- DAO still works, it is MFC that is ... hardcoded to the DAO 3.5 version. ... If you want to move away from DAO, then you should seriously consider ADO - ... (microsoft.public.vc.database)