This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a Access 2016 Database which is split into a back and front end
The backend is placed in the cloud
5 people works with their own front ends
When changed data is saved in the frontend the message appears " Database integrated( the _be filename) alreay exists it will be saved with another name
It then continues to save the file as Database integrated but ads the name of the worker machine . See example
My question..... is the data fron each front end the also stored in the original _ be file or hoe do I get it to save only in one _be file
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi. I agree with Scott. Access is not a "cloud" database. You'll need another system for your back end if you want to use it in the cloud. Cheers!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hi,. I'm an independent adviser and believe I can help.
Unfortunately, the answer is not good. Access just doesn't work that way. If you are using Access tables for your data store, the back end has to be on a local server. Access needs to be able to create a lock file when it opens the back end and can't do that in the cloud. With most cloud storage, the cloud is synced with your local drive. So you are actually working with a local copy which is then synced to the cloud either overwriting or creating a new copy of the cloud file.
The only way to store your data in the cloud would be to use an Azure (or other online) database and link to that.