Link Excel Sheet to Completed Database

[jleekpeek]

I have completed a database that has an excel sheet linked to it. The excel sheet is updated regularly on a shared drive. Recently it has been deleted and the database has lost connection with the excel sheet. A new excel sheet has been created, but the database queries and reports will not connect to the new excel sheet. Does anyone know if I can link the excel sheet without having to re do all of my queries and forms?

 

[Reynod]

Short answer no.

What you need to do is backup both regularly ... so if the sheet is deleted you can just copy the backup into the directory.