Asscess and linked tables
-
Hi ! My application (developped in C++) is using an Access database. The database is actually made of two '*.mdb' files, one being linked to the other with linked tables. It works fine : I use one database, and I can make SQL queries including the linked tables from the other without any troubles. My problem now is if I want to install my app on someone else's computer, the path to the databases is different, but the link is absolute. Thus, the linked tables are not found and my application doesn't work. I know that with Access, there is a menu to update the path of the linked tables, but of course, I don't want to have to do it manually through the Access Application : I want to be able, from my app, to update the linked tables automatically. Problem : I have no idea if it is possible to do that, and how ! Any help ? Thanks ! Jerome
-
Hi ! My application (developped in C++) is using an Access database. The database is actually made of two '*.mdb' files, one being linked to the other with linked tables. It works fine : I use one database, and I can make SQL queries including the linked tables from the other without any troubles. My problem now is if I want to install my app on someone else's computer, the path to the databases is different, but the link is absolute. Thus, the linked tables are not found and my application doesn't work. I know that with Access, there is a menu to update the path of the linked tables, but of course, I don't want to have to do it manually through the Access Application : I want to be able, from my app, to update the linked tables automatically. Problem : I have no idea if it is possible to do that, and how ! Any help ? Thanks ! Jerome
Hi Jerome. I think this Microsoft Support document[^] may have some useful information for you. You may want to look at the Developer Solutions sample program (Solutions9.mdb) referenced in the document.