Creating A Multiuser databse

[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

[MMcCarthy]

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.

[Darknight850]

that is true, i had tested out both of them, and even though i loose a password with the replica, i do like the ease of the synchronization. i did get the startup forms to pop up as well, which is strange that they did not auto open when I tested, but they did when i started using it, so thats fair enough. thank you for your input, i think i will stay with the replication for now, it seems easier for every one this way.