Deleting and Replacing a Linked table

[didiomm]

Hi all:

I have a question about linked tables. My table (excel spreadsheet) sits on another directory from the DB. If I delete the table on this directory and immediately replace it with a table with the same filename, format, etc (only the data has changed) will each database user have to relink the table on their desktop DB? Or will the forms/subforms/reports still maintain their relationships/functions and just display the new data?


Thanks

 

[CJ_London]

will each database user have to relink the table

Providing they are linked to a whole worksheet or range that has not changed then no, they won't.

As with all these things, try it and come back if you experience problems

 

[didiomm]

Thank you for your response! I made the switch, and so far, no issues.