Linked Table Manager -- skip tables with errors
in the Linked Table Manager, skip tables with errors and continue linking with all in the list -- leave the problem tables checked and uncheck the tables that were successfully linked.
At the request of Microsoft, I am creating a new suggestion to separate the multiple ideas from the suggestion here:
so if you voted on that one, remove your vote and vote for this instead, if this is what you want. Thank you
We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.
Would vote for this if I had any more votes. Also the resizable linker window would be appreciated.
When (if) we get to resize the dialog box, can Access please remember the new size?
Yay! Yes! Do skip errors but continue and tell us which tables linked and which did not. Make the path area MUCH wider (or at least let us control that dialog box size).
here is the link for the resizeable suggestion:
it would also be nice to add, or remove characters to the beginning of each linked table name.
For instance, when linking to other systems, all the names might begin with dbo_. One by one, we can rename them, but it would be awesome if the Linked Table Manager could do this for us.
Likewise, we may want to ADD prefix characters to all tables coming from a particular database -- again, we can rename them one by one, or the Linked Table Manager could do that as well.
Perhaps a textbox in the Linked Table Manager to add or remove prefix characters?
Another suggestion is to make the dialog box RESIZEABLE.