Splitting database - not a valid file name - shared drive

[jbd83]

Hello
I am trying to split a simple database using the database splitter tool.
I can save the backend locally no problem but when I try to save to a shared drive (on office 365 / sharepoint) I get:
"Not a valid file name"

Any ideas?
Thanks

 

[Mark_]

What is the name you are trying to save it as?

 

[jbd83]

I created a test database with only one table and query - just called database1 and have tried saving the backend with that generated by the database splitter - which is database1_be

The issue comes when I add the file path - using UNC path as suggested in access online help

has the format:
\\ahsnkss-my.sharepoint.com@SSL\personal\firstname_lastname_organisation_onmicrosoft_com\Documents\database1_be

 

[Pat Hartman]

You cannot use a cloud service as the place to share an Access BE. The sharing process is dependent on Windows locking and that doesn't work across the internet.

If you want to have remote users share your access application, you need to use Citrix or Remote Desktop. OR rewrite the application using a web technology.

Access does NOT work well over the internet Depending on how much data you are dealing with and how well you designed the application, you might get some traction by using Azure as the BE but I haven't had any real success with Azure even though I've been developing Access apps with RDBMS BE's since the early 90's. The people who do report success with Azure are usually running their own cloud and therefore have a lot of control over how it is optimized to work with their Access app. Plus, the Access app was specifically designed to work with Azure across the internet and therefore works differently from the normal Access app developed by non-professionals or even professionals who develop with Jet and ACE BE's or local SQL Server installations.