Reply to thread

Message: [QUOTE="Pat Hartman \(MVP\), post: 2579850"] You can do it by setting the dao.database object to the database you want the link to be in. However, this only works if you have a fixed (and limited) set of front ends that you want to link to back end tables. If you always want your front end to link to ALL tables in the back end, you can look for new tables in your front end's opening form where you can link them regardless of how many front ends you have. If you want to control which tables get linked, you can prefix them and just link the ones with the particular prefix. The name of the table in the source database may be different from it's name in the linking database so you won't have to modify [/QUOTE]