Hi All,
So I was contracted to create a small database for a very small pro bono clinic. I created the front end (.mde) and back end fine. Everything is running fine. Local front end with networked back end.
There are 15 computers that will all be accessing the database for data entry and about 5 for reporting (different front end). I distributed a local copy of the front end .mde to the data entry computers and everything is running smoothly, and then they dropped the bomb on me. The data entry computers are wiped clean every couple days (which no one told me before). The issue is now that I can't have multiple people use the same networked mde because it is locked after one person opens it. I am now on deadline and trying to figure out a quick solution.
My first thought was to assign a different .mde file to each computer, but the office staff is concerned that the data entry people will be confused by the different files and ultimately want a single file that everyone clicks on to get to the database.
My second thought was to create a shell mde file that uses VBA to copy a clean version of the data-entry mde to a temp folder (possibly locally), launches the data-entry mde copy and then closes the shell mde
I am thinking there is probably a much simpler solution, especially since I am not that familiar with VBA and don't know exactly how to copy a networked file to the local system, open it, and close the shell .mde.
Any thoughts before I attempted this endeavor???
So I was contracted to create a small database for a very small pro bono clinic. I created the front end (.mde) and back end fine. Everything is running fine. Local front end with networked back end.
There are 15 computers that will all be accessing the database for data entry and about 5 for reporting (different front end). I distributed a local copy of the front end .mde to the data entry computers and everything is running smoothly, and then they dropped the bomb on me. The data entry computers are wiped clean every couple days (which no one told me before). The issue is now that I can't have multiple people use the same networked mde because it is locked after one person opens it. I am now on deadline and trying to figure out a quick solution.
My first thought was to assign a different .mde file to each computer, but the office staff is concerned that the data entry people will be confused by the different files and ultimately want a single file that everyone clicks on to get to the database.
My second thought was to create a shell mde file that uses VBA to copy a clean version of the data-entry mde to a temp folder (possibly locally), launches the data-entry mde copy and then closes the shell mde
I am thinking there is probably a much simpler solution, especially since I am not that familiar with VBA and don't know exactly how to copy a networked file to the local system, open it, and close the shell .mde.
Any thoughts before I attempted this endeavor???
