Question Multiple users while editing

[shuashef]

I have a split database which there are multiple users on the front end. However, I am constantly making edits on the front end which I am unable to do if someone else is in the database. Is there any way for someone to be entering data while I am simultaneously making edits to the forms and reports?

 

[Mr. B]

Just to be clear; are you indicating that you have split your database but you have the front-end so that multiple user access that file to use it?

In a split database environment, each use should have their own copy of the front-end file on their computer. That file is linked to the data.

You as the developer have your "master" copy of the front-end file in which you do your development of forms, report, etc. When you have updates to the front-end, you simply send a copy of the the new file to each user or implement some "auto-updater" method where you place the new front-end in a shared network location and have code that will copy the new version to each users computer when necessary.

 

[shuashef]

I think the auto-updater would work best as the other users need a little steps as possible to get the most recent version. I'm a little new at this- do you have an example of such code?
Also, can I just make changes in the original version and save it with the same file name and this will automatically be the new version or does a new filename need to be created?

 

[Mr. B]

Here is the link to the Auto FE Updater that I was referring to:
http://autofeupdater.com/

You can just save your changes to the same file with the same name.

I would suggest that you create a version number an place that on your application somewhere so it makes it easier to see which version your users have on their machine.

 

[gemma-the-husky]

you ought to keep a safe copy of the master version of your database

sooner or later you WILL get a corrupted dbs, or form - and you will be pleased you have a clean backup available