Quote:
Originally Posted by Darknight850
Hello every one,
I am having a user problem with my database. I have this database i recently created on a local network, were multiple users open this database. the biggest problem i am running into right now is that were most of the data is getting entered, there network connection is not that good and disconnects and reconnects alot, which runs into a problem every time they try to do something on this because once they keep getting an error saying database is no longer connected to the internet. I have beening looking into creating a replica on the persons computer that enters the data and then just sychronize the data with the one on the network, but it seems as though some features are not avalible. Such as the startup form poping up. Which is a big help when the people enterning data do now know much about what they are doing.
I had also read up on spliting the database, but i do not know to much about that. If any one can give some suggestions or solutions to the problem i am having it would be greatly appriciated
Thank You
If you split the database to a frontend/backend you will only need to synchronise the backend. The frontend can be local to each user. The backend would only contain the tables of data which would be linked to each frontend.
The big problem with this is working out the synchronisation. If any of the users edit data how do you decide on the most up-to-date data to synchronise to.
