Where to put a back end

[Ganymede]

I have built a database that will be used by multple users in my organization (sometimes simultaneously). I have read that the best way to go about this is to split my database into a back end (with all the tables) and a front end (with all the objects and queries and links to the tables from the back end).



I understand that the backend needs to be stored on a network folder where everyone has read-write permissions. I suppose my question becomes what qualifies as a network folder? What about Sharepoint/Teams? One Drive?

[June7]

Definitely not OneDrive. Also think SharePoint is not appropriate. Common topic, search internet.

[mike60smart]

Hi
You should have a folder on your Server which contains both the FE & the BE
Every User will then have a Copy of the FE on their individual PC's

Th following https://support.microsoft.com/en-us/...3-51b1d73498cc explains the process.

[Micron]

The network connection should be wired to minimize corruption. Access over WIFI would be a bad idea. If users are remote, then you need Citrix or whatever they're calling Terminal Services now.

[Ganymede]

Definitely not OneDrive. Also think SharePoint is not appropriate. Common topic, search internet.

Can you tell me why SharePoint is not appropriate? I've read conflicting reports on it. Some say it's no good becasues it has a 5,000 record limit. But others say that only applies if you open the list in web view. (See discussion here.) Is there some other reason to avoid SharePoint? It would be the easiest solution for me and my team. We don't have traditional network folder as far as I'm aware. Everything is on teams.

[Welshgasman]

Hi
You should have a folder on your Server which contains both the FE & the BE
Every User will then have a Copy of the FE on their individual PC's

Th following https://support.microsoft.com/en-us/...3-51b1d73498cc explains the process.

I would not have the FE on the server, if users can get to it.

[June7]

I've never used SharePoint so my understanding is limited. I think SharePoint was intended to be a way to serve Access database on the web. Review https://support.microsoft.com/en-us/...1-322ddbcf5411. Web database construction tools were removed from Access in version I think 2010.

But if the linking described in the reference you posted really works for multi-user interaction, go for it.