Hello,
I have an Access database that holds a number of linked tables (to an other Access file).
In the new situation the data I need to link to are in SharePoint lists (and the old Access file is no longer supported).
The names of the existing tables are the same as on SharePoint.
I know how I can make an external connection to a SharePoint list.
What would be the best procedure to swap the linked existing tables for the new SharePoint list tables?
Can I first break the connection to the old linked tables and then connect to the new SP lists without upsetting all Forms and Queries or should I do this in an other way?
The reason I ask this is because I previously deleted one existing table, connected the corresponding SP list, but now I keep getting the error when I open a Form that the deleted table cannot be found (while the new table has the same name).
Thanks for directions...
BartH_NL