Home Button  Buy Button 

Topic:   multiple users accessing data file at same time

By: EdbfmiPosted on: Feb 28 2019 at 07:12:04 PM
If I have the data file saved on a network attached server and have 2 or more seats working on the program at the same time will it mess up the data file?

By: GuestPosted on: Mar 1 2019 at 08:16:12 AM
See this page:-


Also see the "User manual" button in the bottom right corner of the MiniMRP program window

By: EdbfmiPosted on: Mar 1 2019 at 09:37:25 AM
Thanks for the reply.
I did read the link above but it did not address my question.
Since multiple seats may be addressing the same Data File on the shared network folder my concern is what happens if more then one seat tries to access the data at the same time. Is the software written so that this will insure that all the changes made by either seat will be updated?
I have other software (Quickbooks for one) that will let you know if a particular file is being used by another seat and stop you from making changes until that user completes their task.
We will have multiple seats in various locations in our facility using the system and I am afraid of data loss or corruption

By: GuestPosted on: Mar 1 2019 at 11:57:47 AM
I'm not the support guy - I'm just a user like you. We've got 8 people using the software on a shared folder.

All using at the same time and never had a problem with any data corruption or any popup telling us we had to wait.

I guess if two people were editing (making changes to) the exact same purchase order at the exact same time (minimrp does allow that without conflict) and one user saved his changes and a moment later the other guys saved his changes then one of them is going to overwrite the other but it would only affect that one purchase order - not the whole file. And then you might ask yourself how likely is it anyway that two people would actually ever want to make changes to the exact same purchase order at the same time anyway.

The MiniMRP guys do suggest looking at SQL Server though if you do have a LOT of users especially users connecting from different locations over the internet.

By: Ken at DTSPosted on: Mar 4 2019 at 07:18:57 AM
We have 4 to 5 users who use the software concurrently. The database file is stored on a shared folder of a network drive.

Before deploying the software we performed our own testing to see what would happen if two users tried to modify a component simultaneously. miniMRP behaved "correctly", that is the first user to modify a component locked its record, and the second user received an error message when they tried to save their changes. The second user would have to abandon their changes, reload the component, and re-enter their changes.

By: StevePosted on: Mar 4 2019 at 08:52:36 PM
Could this 'network drive' be a shared OneDrive folder and allow access from two non-networked computers? Obviously both users would have to have full licenses...
I am pretty sure this question has been asked a bunch of times, but I am wondering if V5 was able to support this. In the mean time, we have been coordinating changes by making the changes on one computer, doing a back-up to OneDrive, and then restoring the back up to the other computer to see the changes.

By: SupportPosted on: Mar 5 2019 at 02:32:02 AM
If you occasionally drag a backup or a copy of the MiniMRP data file into 0neDrive so perhaps sales guys out on the road can pick up that backup and restore that into their own copies of MiniMRP just so they can look at reasonably up-to-date inventory availability, prices etc. then that would be fine.

But if you want to have the LIVE data file where everyone is reading/writing into 0neDrive then no. We can not recommend that. I know some people do it and they say it works fine you really shouldn't do it. This has nothing to do with a limitation in MiniMRP. It's a limitation of that kind of drive sharing technology. It simply was not designed to allow multiple users to have simultaneous read/write access to the same file.

If you want to share the database, full read/write access from multiple locations, even different sides of the world, then you should be doing it properly. MiniMRP 'Pro' version includes support for Microsoft SQL Server, MySQL and MariaDB server. If you don't know what that means then get your IT person to set it up for you. The 'free' express and community editions of those SQL Servers are more than enough for MiniMRP so cost is not an issue.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- multiple users accessing data file at same time

Enter the numbers.

Your name here is optional