I have created a Access 07 database that we store employee info along with vaction time requests. The db was intended for maybe a max of 2 people from the resource management team to be in it at a time but was just told that now I have to make it available for the employee's managers. It could be out company network but working in Access over a network is a nightmare when I split it.
I thought about creating a front end for the managers that would pull only their employee info into a temp local table. Once they were done working in records some code would just update the modified records but I think I am making it sound much easier than it really is.
More than anything I am looking for any resources out there that might be able to help with the network issue such as optimizing tips or examples that anyone might know about. At this point I have a split database and I am striping is bare to make it as lean as possible but it just doesnt look like its helping.