I have been working on getting a linked shape to communicate with an Access database using ODBC, it works but I need to be able to locate where the database is and then reference it. ADO can do this I have been told. Is there a string I can put in the shape sheet to reference an ADO datasource? Or is there a way to reference the ODBC source through code and update where it is linked to without using the ODBC administrator.
Any input would be helpful
Thanks
Terry
Any input would be helpful
Thanks
Terry