Instead of linking access to a specific excel file, is there a way to link an excel template to a specific access database?
IMHO, there would be no point. A template cannot hold any data, otherwise it is no longer a template. Plus, Access cannot modify a linked sheet, so that just adds to why I think that would be of no use. You can link specific sheets to Access, and if they are updated, Access sees the updates, but this is not what you're asking for. I also think this is an Excel question seeing as how you seem to be seeking knowledge on how to put buttons on a sheet. Again, just my opinion but I would forget that. If I was going to be adding or working with Excel data from within Access, I'd forget about programming too much on the Excel side. Maybe that's because I'm more familiar with that method; maybe it's because I've dealt with Excel and it's vba and the difficulties it presents with respect to protecting Excel data; especially if the workbook was shared.
As June7 noted, just about anything is possible, but respectfully, this isn't a task for a novice.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.