Hi all,
I'm building an access DB which has a linked table to excel, which is working and all is fine on that front.
What I need to be able to do, is build in functionality that can edit the linked table. As I understand, I can't do this because the data is dependent on the table and can't be overwritten.
To give you some background, what I'm doing is building a supply of workers i.e 10 people across 3 teams and the # of hours they work, to project the resource we have MoM. The aforementioned data is fed from a HR database. This comes through to the access table and what I want to do is build a form that allows me to factor in things like absence and holidays as this db will be used by a centralised team, not HR and HR do not record holidays. Is there a way I can "unlock" the cells to be able to overwrite them OR is it more practical to build a form that updates the source excel sheet directly from the access DB?
If the latter, can anyone offer some pointers? Not shy of VBA but by no means an expert.
Any alternative solutions are much appreciated.
Thanks!
I'm building an access DB which has a linked table to excel, which is working and all is fine on that front.
What I need to be able to do, is build in functionality that can edit the linked table. As I understand, I can't do this because the data is dependent on the table and can't be overwritten.
To give you some background, what I'm doing is building a supply of workers i.e 10 people across 3 teams and the # of hours they work, to project the resource we have MoM. The aforementioned data is fed from a HR database. This comes through to the access table and what I want to do is build a form that allows me to factor in things like absence and holidays as this db will be used by a centralised team, not HR and HR do not record holidays. Is there a way I can "unlock" the cells to be able to overwrite them OR is it more practical to build a form that updates the source excel sheet directly from the access DB?
If the latter, can anyone offer some pointers? Not shy of VBA but by no means an expert.
Any alternative solutions are much appreciated.
Thanks!