Our warehouse site desperately requires a database that runs efficiently, is secure and we can modify ourselves. Unfortunately the Company's policy does not allow any servers on site, only at headquarters. We are allowed to create MS Access databases and modify them, but if we wish them to be run on a SQL server, it has to be supported by IT and we lose access to make any modifications. Access runs like a snail over the network as headquarters is in another state. Even a small file with a simple structure can freeze up or take minutes to open a form.
My question is, is there a solution for our situation? Is it possible to get around all the red tape? How can I argue that they aren't providing what we need and get them to listen?