Access Database questions
I am in no way a programmer, though I can understand when told to do certains things and I know a few (very few) things about programming.
I request help concerning a demand from my employer I have. Here's the situation:
We are a car dealership which employs about 10-12 employees that use the same shared Excel spreadsheet. We log all of our notes on an Excel spreadsheet (aka, we receive a price quote from the internet, we will log in the spreadsheet when we received it, name of the customer, who sent the quote as well as the notes of the rep who ended up calling the customer.)
The problem is that the spreadsheet constantly gets un-shared or just plain deletes itself, so we end up losing follow-up notes that are important, especially to the Director.
I would like to know if there's a way to created a shared Access DB that will auto-update let's say every minute, whether there are changes or not. This way, the employees could keep the file open at all times, whether they need it or not. It would prevent the file from getting un-shared and being closed the wrong way and thus deleted from the server.
I seek thy help, Ô great web panel! hehe